DuckDB SQL
Any SELECT. {{input0}}…{{input2}} name the connected tables; other {{name}} are parameters.
Syntax
{ "id": "n1", "op": "sql", "name": "sql", "x": 0, "y": 0, "params": {} }
An edge into it ends at "targetPort": "in0"; one out of it starts at "sourcePort": "out".
Inputs
| Port | Type | Takes |
|---|---|---|
in0 | table | optional |
in1 | table | optional |
in2 | table | optional |
Parameters
| Parameter | Kind | Default | Choices |
|---|---|---|---|
query | code | "SELECT * FROM {{input0}}" |
Outputs
| Port | Type |
|---|---|
out | table |
Details
- Category: Data
- Operator:
sql
Older projects
Projects saved before documents used operator classes. These convert to sql when they open: CrossOp, DuckDbOp, FilterOp, GeoParquetOp, NetworkOp, PathLayerOp, PolygonLayerOp, RandomizeAttributeOp, ScatterOp, SelectOp, SliceOp, SolidPolygonLayerOp.