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
• Internal scalar flag marks BIND_VALUES rewritten from BIND_VALUE (single scalar, not a multi-row bind)
• 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)))
;