sql_query

Execute a read-only SQL query against workspace data. Tables: records, relationships, collections, workspaces, operations_log. Always include workspace_id = {workspace_id:String} and deleted = false in WHERE. Use FINAL after table name.

Parameters

NameTypeRequiredDescription
workspace_idstringYesTarget workspace ID
querystringYesSELECT SQL query. workspace_id param is auto-injected. Include FINAL, deleted = false, and {workspace_id:String} in WHERE.
paramsobjectNoAdditional named parameters for {param:Type} placeholders
sql_query — Rekor