All functions > ARRAY OF ROWS
All functions in the ARRAY OF ROWS category.
Indexing
| Function | DuckDB | Trino | Serving | Description |
|---|---|---|---|---|
INDEX_UNIQUE() | ✓ | ✓ | ✓ | Returns an index unique computed from the given array and key. |
INDEX_MULTI() | ✓ | ✓ | ✓ | Returns an index multi computed from the given array and key. |
ELEMENT_AT_KEY() | ✓ | ✓ | ✓ | Returns one element at the given key from the given index, array or array of rows. |
ELEMENTS_AT_KEY() | ✓ | ✓ | ✗ | Returns multiple elements at the given key from the given index, array or array of rows. |
Other
| Function | DuckDB | Trino | Serving | Description |
|---|---|---|---|---|
EXTRACT(...) | ✓ | ✓ | ✓ | Returns the extracted fields from the given expression. |
UNWRAP() | ✓ | ✓ | ✓ | Returns the first field values from an array of single-field rows as a simple array. |
UNWRAP_ONE() | ✓ | ✓ | ✓ | Returns the value of the first field of the first element in an array of single-field rows. |
ZIP(...) | ✓ | ✓ | ✓ | Combines multiple arrays into a single array of structured rows with named fields. |
ARRAY_MERGE(...) | ✓ | ✓ | ✓ | Merges multiple arrays of rows element-wise into a single array of combined rows, with optional... |
CARRY(...) | ✓ | ✓ | ✓ | Carries one or more scalar values into each row of an array of rows, adding them as new fields |
EXTEND(...) | ✓ | ✓ | ✓ | Adds computed feature fields to a base row or array of rows with field bindings |
TRANSFORM | ✓ | ✓ | ✓ | Transforms an array of rows using a subquery with optional METHOD |
RECURSE(...) | ✓ | ✗ | ✗ | Produces an array of rows by iterating a seed ROW, optionally traversing entity relationships |
Summary
Functions in this category: 13
This documentation is automatically generated from the FeatureMesh registry.