FunctionsJSON

json_extract_path

Extracts a nested JSON value using variadic path segments (keys or indexes).

json_extract_path(…) → JSON

Kind · scalar

Extracts a nested JSON value using variadic path segments (keys or indexes).

Part of the JSON family.

json_extract_keys_and_values_raw

Returns top-level object entries as key/value pairs where each value remains a raw JSON fragment.

json_extract_path_text

Extracts a nested value via variadic path segments and returns it in textual form.