FunctionsJSON

json_extract_array_raw

Extracts and returns the raw JSON array fragment from the selected path.

json_extract_array_raw(…) → JSON

Kind · scalar

Extracts and returns the raw JSON array fragment from the selected path.

Part of the JSON family.

json_extract_array

Extracts an array value from the provided JSON path and returns it as a JSON array token.

json_extract_bool

Extracts the JSON value at the given path and returns it as a boolean. If the path is missing, the JSON is invalid, or the value cannot be represented as a boolean, the result is NULL.