You can put all your writes in a queue to be processed by a finite set of writers. I think most CRUD applications can afford the delay and if not you can pair it with a write through cache.
Although I definitely would like to use SQLite just for the cost savings for something. Litefs/litestream looks great.