The following table lists the available JSON Table Operators, and a description of their purpose.
|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.|