TRANSFORM_U
All functions > ARRAY_OF_ROWS > TRANSFORM_U
Transforms an array of rows using UNNEST with full SQL query capabilities
Syntax
TRANSFORM_U(from, raw_query, imports)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
from | ARRAYROW | Yes | Array of rows to transform |
raw_query | QUERY | Yes | Raw query representation for unnest query |
Returns
ARRAY[ROW] - Transformed array of rows
Notes
- Uses UNNEST to flatten array into table rows
- Supports full SQL query operations
- Most flexible transformation approach
- Can join with other data sources
- Default TRANSFORM alias points to this implementation
Aliases
TRANSFORM