Querying
Read, filter, embed, write, and call functions over HTTP.
This is the heart of the API. These pages cover reading rows with projection and
pagination, the full operator set for filtering, embedding related resources,
writing data, calling functions at /rpc, full-text search, and how types and
casts behave. Every example runs against the SQLite quick start.
Reading data
Projection, ordering, pagination, and counting with GET.
Operators
The full filter operator set, boolean logic, and value syntax.
Resource embedding
Nest related resources in one request through foreign keys.
Writing data
Insert, update, upsert, and delete, with the PostgREST status rules.
Functions (RPC)
Call database functions over HTTP at /rpc.
Full-text and regex
The fts family and the match operators, and how they lower per backend.
Types and casts
The canonical type surface, operand coercion, and explicit casts.