Today’s article covers BigQuery features I've found myself teaching constantly over the past year. I share at least three of these with every data team I meet. These features solve problems people have worked around for years.
Part of what makes them so useful is that SQL has a structural quirk that we all know too well: you write clauses in a fixed order that doesn’t match the order they actually execute. BigQuery’s GoogleSQL dialect has been shipping fixes for this. The five features below are the ones I keep coming back to.


