JSON query and processing

📄️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

Extracts a floating-point value from a JSON string at the specified path.

📄️get_json_int

Extracts an integer value from a JSON string at the specified path.

📄️get_json_scalar

Parses and gets the scalar value from a specified JSON path in a JSON string, returning NULL if the matched value is an object or array.

📄️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.