📄️ As_<Type>
Strict casting VARIANT values to other data types. If the input data type is not VARIANT, the output is NULL. If the type of value in the VARIANT does not match the output value, the output is NULL.
📄️ CHECK_JSON
Checks the validity of a JSON document. If the input string is a valid JSON document or a NULL, the output is NULL. If the input cannot be translated to a valid JSON value, the output string contains the error message.
📄️ GET
Extracts value from a Variant that contains ARRAY by index, or a Variant that contains OBJECT by field_name. The value is returned as a Variant or NULL if either of the arguments is NULL.
📄️ GET_IGNORE_CASE
Extracts value from a VARIANT that contains OBJECT by the field_name. The value is returned as a Variant or NULL if either of the arguments is NULL.
📄️ GET_PATH
Extracts value from a VARIANT by path_name. The value is returned as a Variant or NULL if either of the arguments is NULL.
📄️ JSON_EXTRACT_PATH_TEXT
Extracts value from a Json string by pathname. The value is returned as a String or NULL if either of the arguments is NULL. This function is equivalent to tovarchar(GETPATH(PARSEJSON(JSON), PATH_NAME)).
📄️ OBJECT_KEYS
Returns an Array containing the list of keys in the input Variant OBJECT.
📄️ PARSE_JSON
Interprets input JSON string, producing a VARIANT value