TRANSFORM_C
All functions > ARRAY_OF_ROWS > TRANSFORM_C
Transforms an array of rows using a correlated subquery
Syntax
TRANSFORM_C(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 correlated subquery |
Returns
ARRAY[ROW] - Transformed array of rows
Notes
- Uses correlated subquery approach for transformation
- Executes subquery for each row in the source
- Can reference outer query fields in subquery
- More powerful than lambda but potentially slower
- Database-dependent implementation