Data API Features

Save Record (Create)

• Single record.
• Bulk records.

Query (Read)

• Row Filtering with rSQL DSL.
• Column Selection
• Rename Columns / Alias
• Join - Inner
• Include Join Columns
• Pagination - Limit & Offset
• Sort / Order by
• Group By
• Count
• Join column filter

Edit

• Patch
• Patch with row filtering

Purge (Delete)

• Delete with row filter.
• Safe delete.

Transactions

• Readonly for Select
• Supported for Save, Edit, Purge

Multi-tenancy

• Tenant Id column
• Schema per tenant
• Database per tenant

Schema Support

• Multiple schema support