Need to build/parse #JSON payloads using #SQL? Check #ApacheFlink functions!
- JSON_BUILD_OBJECT to build an object based on a series of keys and values
- JSON_ARRAYAGG to aggregate values into an array
- JSON_VALUE to retrieve a single field from a JSON object
- JSON_QUERY to retrieve multiple nested records from a JSON object