make_object([options(...)]?, [key_value: storable]*) -> object

Turn a sequence of name:value elements into an object.
Without arguments, returns an empty, non-null object literal.

Options

OptionTypeMeaning
keep_nullsboolDetermines whether key-value pairs with null values are kept in the object (true) or discarded (false). Default is false (discard).

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

Examples

Make a new column 'obj' consisting of an object with keys 'label', 'value', and 'attime'.

Make a new column 'obj' consisting of an empty object that is not 'null'.

Make a new column 'obj' consisting of an object {"apple": null}.