While working on getting JSON support for some Python libraries, I discovered some capabilities IRIS provided.
- JSON_OBJECT - A conversion function that returns data as a JSON object.
- JSON_ARRAY - A conversion function that returns data as a JSON array.
- IS JSON - Determines if a data value is in JSON format.
- JSON_TABLE function returns a table that can be used in a SQL query by mapping JSON.
- JSONPath support - is a query language for querying values in JSON.