JSON query and processing

📄️ Arrow function

Queries an element that can be located by the jsonpath expression in a JSON object and returns a JSON value. The arrow function -> is more compact and easier to use than the jsonquery function.

📄️ 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. json_path must start with $ and use . as the path separator.

📄️ 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 (jsonpath) in a JSON string. If the format of jsonstring or json_path is wrong or if no matching value is found, this function will return NULL.

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

Checks whether a JSON object contains an element that can be located by the jsonpath expression. If the element exists, the JSONEXISTS function returns 1. Otherwise, the JSON_EXISTS function returns 0.