Pay attention to this when UNNESTING in BigQuery

Here's a common confusion that I encounter while working with ARRAYs in BigQuery. This can lead to wrong queries in some situations. Consider the following two snippets: FROM table, UNNEST(repeated_column) AS single_item versus FROM table LEFT JOIN...