Scalar FunctionsDynamic / JSON Functions
bag_set_key
Return the property bag with the given key set to `value`, inserting
Syntax
bag_set_key(bag, key, value)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
print bag_set_key(dynamic({"a":1}), "b", 2)| print_0 (dynamic) |
|---|
| {"a":1,"b":2} |
bag_remove_keys
Remove specified keys from a property bag.
column_ifexists
If a column named `column_name` exists in the current row set, return its value for the current row; otherwise evaluate and return `default`. Resolved at query compile time, so the column name must be a constant string and the default's type is ignored when the column exists.