CRUD & Querying

This section covers CRUD and querying via Generated APIs — typed endpoints auto-generated from your table schemas.

API	Endpoint	Best for
Generated GraphQL	/endpoint/graphql/.../head, /draft, or specific revision	Frontend apps, typed queries
Generated REST	/endpoint/rest/.../head, /draft, or specific revision	Backend services, REST consumers, typed OpenAPI

For full platform management (create/delete tables, rename, schema changes, search, commits), see System API. For AI agents, see MCP.

Operations

CRUD

Create, read, update, patch, and delete rows — single and bulk operations.

Querying

Feature	Description
Filtering	WHERE conditions — string, numeric, boolean, array, logical operators
Sorting	Order by system or data fields with type casting
Pagination	Cursor-based (Relay-style) forward pagination
Relationships	Auto-resolved FK fields in GraphQL queries