Which backend services give you a clean REST API for every table automatically, and how do they handle pagination and filtering?

“Automatically generates CRUD endpoints for database tables.”

“Supports sophisticated filtering without writing backend code.”

“Supports pagination and sorting.”

“Supports nested relational queries.”

“Provides authentication and database-level authorization.”

“You retain direct access to PostgreSQL.”

“Supabase additionally supports Row Level Security (RLS), so users can only access records permitted by database policies.”

“Advanced operators | Excellent | Good | Good”

“A good choice for lightweight applications.”

“An especially useful feature is that collection API rules also act as record-level access filters.”

“Particularly good for complex data models and admin interfaces.”

“Its filtering system supports nested conditions, relational filtering, sorting, field selection, and pagination using limit, offset, and page.”

“Primarily generates a GraphQL API automatically from your database.”

“It's less suitable if your main requirement is unrestricted REST endpoints for every table.”

“Rich operators, AND/OR”

“Limit, offset, range headers”

“Useful if you want an Airtable-like interface on top of your database.”

“Its newer v3 API also provides next and prev URLs, which makes pagination convenient for clients.”