FunctionsJSON

json_query

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

json_query(…) → JSON

Kind · scalar

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

Part of the JSON family.

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_set

Updates a JSON document by setting the value at a specified path. V1 supports top-level object-key and array-index updates with strict path validation.