I’m interested in how this space evolves to take advantage of (eg) Cloudflare Durable Objects, etc.
Yep. You could also potentially implement SQLite VFS on top of the Durable Objects specification to make it work within wasm runtime. It would be interesting to explore asynchronous messaging (a.k.a. email server) in this context.