[ https://issues.apache.org/jira/browse/CALCITE-6365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-6365: ------------------------------------ Labels: pull-request-available (was: ) > Support for RETURNING clause of JSON_QUERY > ------------------------------------------ > > Key: CALCITE-6365 > URL: https://issues.apache.org/jira/browse/CALCITE-6365 > Project: Calcite > Issue Type: New Feature > Reporter: Dawid Wysakowicz > Priority: Major > Labels: pull-request-available > > 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. > {code} > <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> ] > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)