> so a web app can run SQL queries locally and all the usual SQLite stuff "just works" from the warm/javascript's point of view
Duckdb-wasm can do this.
Duckdb-wasm can do this.
I think one day I'm gonna have a thing where I need a few GB or tens of GB of database to be available in a web or mobile app, but where that db rarely changes, and I want to do this without having to support/secure a backend platform or database.