Skip to main content

expand_posexplode_duckdb

polyglot_sql::transforms

Function expand_posexplode_duckdb 

Source 
pub fn expand_posexplode_duckdb(expr: Expression) -> Result<Expression>
Expand description

Expand POSEXPLODE in SELECT expressions for DuckDB.

Converts SELECT POSEXPLODE(x) to SELECT GENERATE_SUBSCRIPTS(x, 1) - 1 AS pos, UNNEST(x) AS col Handles both aliased and unaliased forms:

  • SELECT POSEXPLODE(x) AS (a, b) -> SELECT GENERATE_SUBSCRIPTS(x, 1) - 1 AS a, UNNEST(x) AS b
  • SELECT * FROM POSEXPLODE(x) AS (a, b) -> SELECT * FROM (SELECT GENERATE_SUBSCRIPTS(x, 1) - 1 AS a, UNNEST(x) AS b)