Object Functions This section provides reference information for object functions in TiDB Cloud Lake. Object functions enable creation, manipulation, and extraction of information from JSON object data structures.
Object Construction Function Description Example OBJECT_CONSTRUCT Creates a JSON object from key-value pairs OBJECT_CONSTRUCT('name', 'John', 'age', 30) → {"name":"John","age":30}OBJECT_CONSTRUCT_KEEP_NULL Creates a JSON object keeping null values OBJECT_CONSTRUCT_KEEP_NULL('a', 1, 'b', null) → {"a":1,"b":null}
Function Description Example OBJECT_KEYS Returns all keys from a JSON object as an array OBJECT_KEYS({"name":"John","age":30}) → ["name","age"]
Object Modification Function Description Example OBJECT_INSERT Inserts or updates a key-value pair in a JSON object OBJECT_INSERT({"name":"John"}, "age", 30) → {"name":"John","age":30}OBJECT_DELETE Removes a key-value pair from a JSON object OBJECT_DELETE({"name":"John","age":30}, "age") → {"name":"John"}
Object Selection Function Description Example OBJECT_PICK Creates a new object with only specified keys OBJECT_PICK({"a":1,"b":2,"c":3}, ["a","c"]) → {"a":1,"c":3}