Yes, see https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select_as_struct https://cloud.google.com/bigquery/docs/reference/standard-s

Yes, see https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#select_as_struct https://cloud.google.com/bigquery/docs/reference/standard-sq... and https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#unnest_operator https://cloud.google.com/bigquery/docs/reference/standard-sq.... Very pleasant compared to normal SQL. Table-valued functions (I think these are not exclusive to GoogleSQL?) are also very nice. Every time I see scripts with a long block of with statements part of me dies inside.