Skip to main content

SQL Runner

Type: sql-runner

Named SQL source for other SQL widgets.

Supports children: Yes

Runs a DuckDB query and exposes its result as a named SQL source. Any SQL widget in reach of this node (the same node, or one connected by an edge) references the result via {{name}}; children are rendered as given.

Example

{
"type": "sql-runner",
"props": {
"name": "filtered_data",
"sql": "SELECT * FROM {{my_udf}} WHERE price < $max_price",
"maxRows": 10000
},
"children": [
{ "type": "bar-chart", "props": { "sql": "SELECT category AS label, COUNT(*) AS value FROM {{filtered_data}} GROUP BY 1" } }
]
}

Every widget is defined as { "type": "sql-runner", "props": { ... } }. The properties below describe the props object.

Props

Loading ....

Raw schema

Download the full schema file: /widget-schema/sql-runner.json