[BEAM-9777] Support UNNEST(ARRAY[STRUCT()])

• Type: New Feature
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Component/s: dsl-sql-zetasql
• Assignee: Unassigned
• Reporter: Andrew Pilloud
• Created: 17/Apr/20 17:56
• Updated: 04/Jun/22 15:37

Description

It would be nice to be able to UNNEST an array of structs. For example:

WITH pcol AS
  (SELECT 1 AS key, ARRAY[STRUCT("abc" AS name, "rst" AS slot),STRUCT("def" AS name, "uvw" AS slot)] AS promo
  UNION ALL
  SELECT 2 AS key, ARRAY[STRUCT("ghi" AS name, "xyz" AS slot)] AS promo)

SELECT * FROM pcol, UNNEST(pcol.promo);