Is there anything similar for Sqlite?

Don't overlook https://datasette.io/ even though it does much more than endpoints.

Yes. Search the table at https://github.com/dbohdan/automatic-api for "SQLite". Disclosure: this is my repository.

Exactly that (same api structure) https://docs.subzero.cloud/

Wow; this is extremely nice for quick prototyping!

I use it in production. Handling roles and permissions in the DB is a game changer.

But beware row-level security. It's great, but the query planning is a huge mess, and you can end up with serious performance issues real fast if you're not careful.

My understanding, perhaps flawed, is that row security policies add predicates to the SQL, which then encounters the query planner like any other. Is this not the case?

At one point, I really thought it was used in Supabase. But I guess they only wrote the js wrapper for it. https://github.com/supabase/postgrest-js

Came here to mention Hasura as well (not sure of it's popularity though) https://hasura.io/graphql/database/postgresql

They do use it:

- https://supabase.com/docs/guides/api#rest-api-overview

- https://supabase.com/docs/guides/getting-started/architectur...

I would not recommend Hasura if you're on PostgreSQL.