.KeyValue() (SQL/JSON Path Item Method)

1. ⚡Returns null
2. ⚡Returns the input object

SELECT JSON_QUERY(j,'$.keyvalue()' WITH ARRAY WRAPPER)
  FROM (VALUES ('{"k":"v", "k2": 42}')) t(j)

This example returns the following JSON array where each entry represents a key/value pair from an object. The “id” property can be used to match those key/value pairs that originate from the same JSON input object together.

[ {"id": 0, "key": "k",  "value": "v"}
, {"id": 0, "key": "k2", "value": 42 }
]

Variants

Like any other item method, .keyvalue() can be used in the main expression as well as in filters.

1. Returns null
2. Returns the input object

Related

• Primer: JSON Path

Normative References

The SQL/JSON-Path item method .keyvalue() is part of the optional feature T821, “Basic SQL/JSON query operators” of ISO/IEC 9075-2:2023.