Data Operations
Data CRUD operations
RPC Call
Call stored procedures or custom functions in PostgreSQL (powered by PostgREST RPC). Supports passing parameters and returns function execution results.
Query Records
Query data in table, supports complex queries, join queries, pagination, sorting, etc.
Count Data Records
Count data records in table that match conditions
Insert or Upsert Records
Insert single or multiple records, supports upsert operation
Update Records
Update data according to conditions, WHERE conditions must be provided
Delete Records
Delete data according to conditions, WHERE conditions must be provided