JSON functions

Parse JSON, extract values from it and build JSON output.

Function	Type	What it does
`from_json`	Scalar	Parses JSON text according to a literal SQL schema.
`get_json_object`	Scalar	Extracts a JSON value from text using a path.
`get_path`	Scalar	Extracts a value from a VARIANT using a path and returns it as VARIANT.
`json_extract`	Scalar	Extracts a JSON value from text using a path.
`json_extract_scalar`	Scalar	Extracts a scalar value from JSON text as a string.
`json_format`	Scalar	Compacts and normalizes valid JSON text.
`json_value`	Scalar	Extracts a scalar value from JSON text as a string.
`parse_json`	Scalar	Parses JSON text into a VARIANT value.
`to_json`	Scalar	Serializes a SQL struct, array or map value to JSON text.
`try_parse_json`	Scalar	Parses JSON text into a VARIANT value and returns NULL for per-row parse failures.
`try_variant_get`	Scalar	Extracts a VARIANT value at a path and converts it to a requested SQL type.
`variant_get`	Scalar	Extracts a VARIANT value at a path and converts it to a requested SQL type.

Last modified on November 3, 2026