SELECT AS STRUCT and SELECT AS VALUE

Ever heard about value tables in BigQuery? Well, neither have I, until I've seen them mentioned in the docs. So, while in a normal table, a row is made up of columns, in a value table the row is a STRUCT. Say you UNNEST order_lines AS order_line. The...