WITH expressions in BigQuery

So I recently discovered the WITH expression in BigQuery SQL. Not to be confused with the WITH clause, which we use to define common table expressions (CTEs). 👉 What does a WITH expression do?It lets you define a series of variables, scoped to a sin...