Function geometryExpr

  • geometryExpr(plan): string
  • Experimental

    SQL expression that yields a DuckDB GEOMETRY from the stored geometry column, adapting to the physical encoding.

    Parameters

    Returns string

    Throws

    for a geoarrow-* encoding — GeoParquet 1.1 native columns are nested STRUCT/LIST values with no DuckDB spatial-predicate expression. Callers must fail closed before constructing SQL rather than let a malformed ST_Intersects(...) reach DuckDB; use a bbox-covering column for spatial pushdown and the dedicated native decoder for geometry projection instead.

Settings

Member Visibility