[CALCITE-6365] Support for RETURNING clause of JSON_QUERY

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.38.0
• Labels: pull-request-available
• Assignee: Dawid Wysakowicz
• Reporter: Dawid Wysakowicz
• Created: 15/Apr/24 09:33
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

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> ]

In this issue I'd like to support only part of the full specification, namely:

<JSON output clause> ::=
  RETURNING <data type>

Issue Links

• is caused by: FLINK-35216 Support for RETURNING clause of JSON_QUERY
• links to: GitHub Pull Request #3771