[BEAM-14450] Support Structs referencing other tables

• Type: New Feature
• Status: Triage Needed
• Priority: P2
• Resolution: Unresolved
• Component/s: dsl-sql-zetasql
• Assignee: Unassigned
• Reporter: Andrew Pilloud
• Created: 09/May/22 19:39
• Updated: 05/Jun/22 00:22

Description

Looks like we still have failing tests on ZetaSQL tagged as BEAM-9378:
java.lang.UnsupportedOperationException: Does not support expr node kind RESOLVED_MAKE_STRUCT

org.apache.beam.sdk.extensions.sql.zetasql.ZetaSqlDialectSpecTest.testStructOfStructRemap

The case that doesn't work is Structs referencing other tables. For example `SELECT STRUCT(column) FROM table`