FunctionsJSON

json_pretty

Formats a JSON value as a human-readable string with indentation and line breaks. Use this for debugging and logs, not for stable storage formats.

json_pretty(…) → String

Kind · scalar

Formats a JSON value as a human-readable string with indentation and line breaks. Use this for debugging and logs, not for stable storage formats.

Part of the JSON family.

json_path_query_tz

Evaluates a SQL/JSON path expression against a JSON document. Returns the JSON value(s) matched by the path as a JSON result. Time-zone-aware variants use an explicit time zone when interpreting te…

json_query

Evaluates a SQL/JSON path and returns the result as JSON. Use this when you expect an object/array or multiple matches.