siftio.marouane-kouskous.workers.dev

run_sql

Run a read-only SQL SELECT against the local DuckDB vault. Tables are named by the `table` field from list_datasets. Use this to join across datasets. At most 1000 rows are returned. The result echoes the `sql` that ran — quote it when you report a number, so the reader can see what was counted. Amounts may be negative where a dataset records refunds; excluding them is a different question, so say which you did.

Input schema

{
  "type": "object",
  "required": [
    "sql"
  ],
  "properties": {
    "sql": {
      "type": "string",
      "description": "A single SELECT statement."
    }
  }
}