The following table lists the available JSON Table Operators, and a description of their purpose.
| Operator | Description |
|---|---|
| JSON_KEYS | The JSON_KEYS table operator parses a JSON instance, from either CHAR or VARCHAR input and returns a list of key names. JSON_KEYS supports both LATIN and UNICODE character sets. |
| JSON_PUBLISH | JSON_PUBLISH is a table operator that is used to compose a JSON data type instance or instances from a variety of data sources, basically anything that can be referenced in an SQL statement. It can publish data into any supported JSON format, including the binary storage formats. JSON_PUBLISH also has the ability to aggregate data larger than 64K into a JSON document. |
| JSON_TABLE | JSON_TABLE creates a temporary table based on all, or a subset, of the data in a JSON object. |