JSON_TABLE is a SQL extension that creates a relational view of JSON data.

The JSON)PATH function provides XPath-like syntax for JSON structures. It provides a way to extract parts of a given document.

Evaluates a key-value pair and returns a JSON object containing the pair

Returns the listed values. The list can be empty. Array values must be of type string, number, object, array, boolean or null.

The JSON_EXTRACT function can extract individual values from a JSON object

Returns the number of elements in a JSON array within a JSON object. It returns the values based on the JSON path passed as the second argument to the function.

Returns the sum of the numeric values of a JSON array within a JSON object

Returns the lowest numeric value of a JSON array within a JSON object

Returns the highest numeric value of a JSON array within a JSON object

Returns the average value of a JSON array within a JSON object

Constructs an aggregation object member for each key-value pair and returns a single JSON object that contains those object members

Converts aggregation of each input SQL expression to a JSON value, and returns a single JSON array that contains those JSON values.