Gustavo de Morais created FLINK-37175: -----------------------------------------
Summary: Support JSON built-in function for JSON_OBJECT Key: FLINK-37175 URL: https://issues.apache.org/jira/browse/FLINK-37175 Project: Flink Issue Type: New Feature Components: Table SQL / API Reporter: Gustavo de Morais Fix For: 2.0.0 It is currently not possible to declare a SQL string that contains existing JSON as valid JSON for JSON_OBJECT. If you do something like {{JSON_OBJECT(KEY 'K' VALUE '\{"value": 42}'), you'll have a string, \{"K", "{"value": 42}"}, as output, an not a json object.}} We should support the JSON() function, at least initial support for it until this function returns the JSON datatype. Example: {{}} {code:java} {code} {{jsonObject(JsonOnNull.NULL, "nested", json('\{"value": 42}'))}} {{JSON_OBJECT(KEY 'K' VALUE JSON('\{"value": 42}'))}} {{// \{"nested":{"value":42}}}} {code:java} {code} {{}} {{}} -- This message was sent by Atlassian Jira (v8.20.10#820010)