That is an interesting approach.
> 6) SQLite is a proven, stable, and well-liked standard.
How does adding this adapter on top affect the stability?
Have you looked at SurrealDB? - https://surrealdb.com/
Seems like it would provide you with what you need.