FunctionsJSON

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.

row_to_json(…) → JSON

Kind · scalar

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.

Part of the JSON family.

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.

to_json

Converts an input value into its JSON representation, preserving JSON inputs and encoding non-JSON scalar values using NYXDB's canonical mapping.