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

SQL Generated

SELECT
  category,
  COUNT(*) AS count,
  ROUND(AVG(revenue), 2) AS avg_revenue
FROM data
GROUP BY category
ORDER BY avg_revenue DESC

Try this operation →

Notes

Null values are handled gracefully - operations skip or preserve nulls where appropriate.
You can edit any pipeline step by clicking on its card to re-open the panel with the same settings.
The SQL preview shows exactly what will execute - inspect it before applying.