Pass data through unchanged (no-op)
Table-in, table-out — composes downstream of SELECTs.
THEN PASS| name | type | description |
|---|---|---|
| _table | TABLE | — |
Leaves the incoming rows unchanged
SELECT
*
FROM
(
VALUES
(1),
(2)
) AS t (x) THEN PASS THEN PYTHON (
'result = pd.DataFrame({"sum_x":[int(df["x"].sum())]})'
)Apply theme styling to a chart specification
Analyze query results with LLM based on a prompt
Remove duplicate rows
Add LLM-computed columns to query results
Filter query results using LLM-based semantic matching
Group by column and aggregate another
Pass data through unchanged (no-op)
Table-in, table-out — composes downstream of SELECTs.
THEN PASS| name | type | description |
|---|---|---|
| _table | TABLE | — |
Leaves the incoming rows unchanged
SELECT
*
FROM
(
VALUES
(1),
(2)
) AS t (x) THEN PASS THEN PYTHON (
'result = pd.DataFrame({"sum_x":[int(df["x"].sum())]})'
)Apply theme styling to a chart specification
Analyze query results with LLM based on a prompt
Remove duplicate rows
Add LLM-computed columns to query results
Filter query results using LLM-based semantic matching
Group by column and aggregate another