sql_query

Execute a read-only SQL query against database data. Tables: documents, relationships, collections, databases, operations_log. Always include database_id = {database_id:String} and deleted = false in WHERE. Queries return the latest version of each row automatically.

Parameters

NameTypeRequiredDescription
database_idstringYesTarget database ID
querystringYesSELECT SQL query. database_id param is auto-injected. Include deleted = false and {database_id:String} in WHERE.
paramsobjectNoAdditional named parameters for {param:Type} placeholders
sql_query — Rekor