simonw's sqlite-utils can be helpful for executing table changes:

https://sqlite-utils.datasette.io/en/stable/python-api.html#...

https://sqlite-utils.datasette.io/en/stable/cli-reference.ht...

> Also it doesn't allow you to use multiple application servers.

Not in the same way you use postgres etc, but you can do it with sharding or with LiteFS, but you do have to consider carefully how you scale your app.

I'm not _really_ disagreeing with you, but I think you're painting with a bit too broad of a brush.