Skip to main content

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​

PortTypeTakes
in0tableoptional
in1tableoptional
in2tableoptional

Parameters​

ParameterKindDefaultChoices
querycode"SELECT * FROM {{input0}}"

Outputs​

PortType
outtable

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.