FunctionsJSON

json_value

Extracts a scalar textual value from a JSON input. This version supports direct scalar extraction and root path '$'.

json_value(…) → String

Kind · scalar

Extracts a scalar textual value from a JSON input. This version supports direct scalar extraction and root path '$'.

Part of the JSON family.

json_typeof

Returns the JSON type of the input value (object, array, string, number, boolean, or null). Use this for schema discovery and conditional extraction.

json_values

Evaluates a SQL/JSON path and returns all scalar matches as a JSON array. If the path resolves to a scalar token, the result is a single-element array.