SQL Query
Write custom SQL
What It Does
SQL Query lets you write arbitrary DuckDB SQL. Full access to the SQL engine for anything the visual operations don't cover. Reference your data as the table name shown in the tab.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "SQL Query". It's in the Advanced group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
SQL | Text area | Yes | Your DuckDB SQL query |
Example Query
SELECT
category,
COUNT(*) AS count,
ROUND(AVG(revenue), 2) AS avg_revenue
FROM data
GROUP BY category
ORDER BY avg_revenue DESC