Migrating Teradata Column Alias References to BigQuery: The UNNEST Pattern Explained

TL;DR: Teradata lets you reference column aliases within the same SELECT statement — BigQuery doesn't. During migration, the workaround is a clever CROSS JOIN UNNEST pattern that preserves logic witho