Maps & structs Scalar

struct_insert()

Adds field(s)/value(s) to an existing STRUCT with the argument values. The entry name(s) will be the bound variable name(s)

Arguments & returns

Scalar

Overload link	… Varargs	Returns
#01	`ANY`	`STRUCT`

… accepts a variable number of arguments of the type shown.

SELECT struct_insert({'a': 1}, b := 2);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT OBJECT_INSERT(OBJECT_INSERT(OBJECT_INSERT(OBJECT_CONSTRUCT('key5', 'value5'), 'key1', 5), 'key2', 2.2), 'key3', 'value3')

In DuckDB

SELECT STRUCT_INSERT(STRUCT_INSERT(STRUCT_INSERT({'key5': 'value5'}, key1 := 5), key2 := 2.2), key3 := 'value3')