The relationship between ARRAY_AGG and UNNEST

title: "The relationship between ARRAY_AGG and UNNEST" seoTitle: "BigQuery ARRAY_AGG vs UNNEST: Opposite Operations Explained" seoDescription: "ARRAY_AGG packs rows into an ARRAY and UNNEST unpacks an ARRAY back into rows — they are inverse operation...