I'd recommend checking out PostgREST for this (if you're using Postgres). We used this approach in my previous startup quite successfully.
We also have plans at Supabase[1] to make Postgres databases semi-ephemeral. You'll be able to spin them up/down using a restful API. The schemas/types will be accessible via a restful API: https://supabase.github.io/pg-api/. Not quite as simple as SQLite, but a good alternative.
> making a database look like an rpc api
I'd recommend checking out PostgREST for this (if you're using Postgres). We used this approach in my previous startup quite successfully.
We also have plans at Supabase[1] to make Postgres databases semi-ephemeral. You'll be able to spin them up/down using a restful API. The schemas/types will be accessible via a restful API: https://supabase.github.io/pg-api/. Not quite as simple as SQLite, but a good alternative.
Databases are cool.
[1] https://supabase.io