UNNEST
Expands an array into a set of rows.
Analyze Syntax
func.unnest([1, 2, 3])
Analyze Examples
# Used in FROM clause
# SELECT * FROM UNNEST([1, 2, 3])
SQL Syntax
UNNEST([1, 2, 3])
SQL Examples
SELECT * FROM UNNEST([1, 2, 3]) AS t(val);
┌─────┐
│ val │
├─────┤
│ 1 │
│ 2 │
│ 3 │
└─────┘