FunctionsJSON

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.

json_set(…) → JSON

Kind · scalar

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.

Part of the JSON family.

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_set_lax

Updates a JSON document by setting the value at a specified path using lax error handling. V1 supports top-level object-key and array-index updates and leaves unsupported paths unchanged.