[jira] [Created] (CALCITE-2251) Support AS STRUCT syntax to create named STRUCT in SQL similar to Google BigQuery

[Shuyi Chen (JIRA)]

Shuyi Chen created CALCITE-2251:
-----------------------------------

             Summary: Support AS STRUCT syntax to create named STRUCT in SQL 
similar to Google BigQuery
                 Key: CALCITE-2251
                 URL: https://issues.apache.org/jira/browse/CALCITE-2251
             Project: Calcite
          Issue Type: New Feature
          Components: core
            Reporter: Shuyi Chen
            Assignee: Shuyi Chen


See [Google BigQuery 
grammar|https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax].

We want to support something like the following:
{code:java}
SELECT STRUCT(a as first_name, b as last_name, STRUCT(c as zip code, d as
street, e as state) as address) as record FROM example_table
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)