generate_subscripts()

Arguments & returns

Macro

Overload link	`arr`	`dim`	Returns
#01	`unknown`	`unknown`	`unknown`

unnest(generate_series(1, array_length(arr, dim)))

SELECT POSEXPLODE(x) AS (a, b)

In DuckDB

SELECT GENERATE_SUBSCRIPTS(x, 1) - 1 AS a, UNNEST(x) AS b