FunctionsJSON

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.

json_values(…) → JSON

Kind · scalar

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.

Part of the JSON family.

json_value

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

row_to_json

Builds a JSON object from the current row arguments. Each argument is emitted as f1, f2, ... and converted with the native SQL-to-JSON mapping.