BIND_VALUES()

All functions > CORE > BIND_VALUES()

Binds the given array of values to the given feature or features.

Signatures

Returns: A table with the array values unnested into rows and columns

BIND_VALUES(array: ARRAY<ROW<T>>, [ordinality: BOOLEAN]) → TABLE<T>

Notes

• Converts an array into a table structure for feature binding
• Unnests array elements into individual rows
• Can handle both simple arrays and arrays of row structures
• Optional ordinality parameter adds row numbering
• Supports mapping array elements to named features
• Used in feature materialization from array data
• Part of the FeatureMesh binding system

Examples

Array of scalars: one input, multiple rows

WITH
    INPUT1 := INPUT(BIGINT),
    CALCULATED := INPUT1 + 1
SELECT
    INPUT1,
    CALCULATED,
FOR
    INPUT1 := BIND_VALUES(ARRAY[1, 3, 5]),
;

Array of rows: multiple inputs in lockstep

WITH
    INPUT1 := INPUT(BIGINT),
    INPUT2 := INPUT(BIGINT),
    CALCULATED := INPUT1 + INPUT2
SELECT
    INPUT1,
    INPUT2,
    CALCULATED
FOR
    (INPUT1, INPUT2) := BIND_VALUES(ARRAY[ROW(1, 2), ROW(3, 4), ROW(5, 6)]),
;