[FLINK-35216] Support for RETURNING clause of JSON_QUERY

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 1.20.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Dawid Wysakowicz
• Reporter: Dawid Wysakowicz
• Created: 23/Apr/24 11:08
• Updated: 13/Aug/24 01:39
• Resolved: 23/May/24 14:12

Description

SQL standard says JSON_QUERY should support RETURNING clause similar to JSON_VALUE. Calcite supports the clause for JSON_VALUE already, but not for the JSON_QUERY.

<JSON query> ::=
  JSON_QUERY <left paren>
      <JSON API common syntax>
      [ <JSON output clause> ]
      [ <JSON query wrapper behavior> WRAPPER ]
      [ <JSON query quotes behavior> QUOTES [ ON SCALAR STRING ] ]
      [ <JSON query empty behavior> ON EMPTY ]
      [ <JSON query error behavior> ON ERROR ]
      <right paren>

<JSON output clause> ::=
  RETURNING <data type>
      [ FORMAT <JSON representation> ]

Issue Links

• causes: CALCITE-6365 Support for RETURNING clause of JSON_QUERY
• relates to: FLINK-35687 JSON_QUERY should return a well formatted nested objects/arrays for ARRAY<STRING>
• links to: GitHub Pull Request #24704