sql_query
Execute a read-only SQL query against database data. Tables: records, relationships, record_types, bases, operations_log. Always include BOTH org_id = {org_id:String} AND base_id = {base_id:String}, plus deleted = false, in WHERE (a database id is per-org, not globally unique, so org_id is required to isolate your data). Queries return the latest version of each row automatically.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
base_id | string | Yes | Target database ID |
query | string | Yes | SELECT SQL query. Both {org_id:String} and {base_id:String} are auto-injected server-side; include `org_id = {org_id:String} AND base_id = {base_id:String}` and `deleted = false` in WHERE. |
params | object | No | Additional named parameters for {param:Type} placeholders |