One alternative is to use pglite [1] which is Postgres compiled to WASM. It can act as a sqlite replacement during development, then when you are ready to move to a server model your SQL is already in Postgres format.
In the WASM Component Model, there's a Postgres example available where the database runs in Docker. I'm hoping they whip up a version that uses SQLite instead, but with a similar WIT interface, and drop the Docker nonsense.
Or anything that can embed a WASM runtime I imagine.
They're considering a native build as well, search term "libpglite".
Though I feel like providing it as a library would work very well initially. Roll a suitable minimal WASM runtime and a WASM blob into a single package, separately for every language.
[1]: https://pglite.dev/