DB
FunctionsArray

array_first_or_null

Behaves like array_first while explicitly preserving null output for empty inputs.

array_first_or_null(…) → String

Kind · scalar

Behaves like array_first while explicitly preserving null output for empty inputs.

Part of the Array family.

array_first_index

Returns a one-based position of the first matching element, or zero when no element matches.

array_flatten

Expands inner array elements into a single output array while preserving left-to-right order.