[FLINK-9161] Support STRUCT syntax to create named STRUCT in SQL

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Component/s: Table SQL / API
• Labels: auto-unassigned
• Assignee: Unassigned
• Reporter: Shuyi Chen
• Created: 12/Apr/18 08:32
• Updated: 17/Jan/23 22:18
• Resolved: 30/Apr/21 03:41

Description

As discussed in calcite dev mailing list, we want add support for adding named structure construction in SQL, e.g.,

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

This would require adding necessary change in Calcite first.

Issue Links

• is blocked by: CALCITE-2251 Support AS STRUCT syntax to create named STRUCT in SQL similar to Google BigQuery