ποΈ Arrow function
Queries an element that can be located by the `json_path` expression in a JSON object and returns a JSON value.
ποΈ cast
Converts a value between the JSON type and SQL type.
ποΈ get_json_bool
Parses and gets the boolean value from a specified JSON path in a JSON string.
ποΈ get_json_double
This function analyzes and gets the floating point value from a specified path in json string.
ποΈ get_json_int
This function analyzes and gets the integer value from a specified path in json string.
ποΈ get_json_string,get_json_object
Analyzes and gets strings from the specified path (`json_path`) in a JSON string.
ποΈ json_contains
Checks whether a JSON document contains a specific value or subdocument.
ποΈ json_each
Expands the outermost elements of a JSON object into a set of key-value pairs held in two columns and returns a table that consists of one row for each element.
ποΈ json_exists
Checks whether a JSON object contains an element that can be located by the `json_path` expression.
ποΈ json_keys
Returns the top-level keys from a JSON object as a JSON array, or, if a `path` is specified, the top-level keys from the path.
ποΈ json_length
Returns the length of a JSON document.
ποΈ json_pretty
Formats a JSON document into an easy-to-read, indented string format.
ποΈ json_query
Queries the value of an element that can be located by the `json_path` expression in a JSON object and returns a JSON value.
ποΈ json_remove
Removes data from a JSON document at one or more specified JSON paths and returns the modified JSON document.
ποΈ json_set
Inserts or updates data in a JSON document at one or more specified JSON paths and returns the modified JSON document.
ποΈ json_string
Converting JSON object to JSON string
ποΈ to_json
Converts a Map or Struct value into a JSON string.
