add support to JSON_KEYS in SQL

The JSON_KEYS() function is used to extract the property names (keys) from a JSON object, without retrieving their associated values.

This is particularly useful when working with JSON objects that contain dynamic property names, meaning that the names of the properties are not known in advance.

1. Extracting top-level keys

SELECT JSON_KEYS('{"name": "Alice", "age": 30}');

The JSON object contains two properties:

{  "name": "Alice",  "age": 30}

Expected result:

["name", "age"]

The function returns a JSON array containing the property names, rather than their values.

2. Extracting keys from a nested object

SELECT JSON_KEYS(    '{"person": {"name": "Alice", "age": 30}}',    '$.person');

In this example, the JSON structure is:

{  "person": {    "name": "Alice",    "age": 30  }}

The second parameter:

'$.person'

specifies the JSON path of the object whose keys should be extracted.

Expected result:

["name", "age"]

If the function were applied to the root object instead, the result would be:

["person"]

Idea priority

Low

Post comment

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Shape the future of IBM!

Search existing ideas

Post your ideas

Specific links you will want to bookmark for future use

add support to JSON_KEYS in SQL

1. Extracting top-level keys

2. Extracting keys from a nested object

Please enter your email address

RELATED IDEAS

add support to JSON_KEYS in SQL

1. Extracting top-level keys

2. Extracting keys from a nested object