The Data Letter

The Data Letter

Earlier Work: Data and AI

5 BigQuery Features That Changed How I Write SQL

Modern BigQuery SQL Features for Senior Engineers

Auditing AI's avatar
Auditing AI
Apr 05, 2026
∙ Paid

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.

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2026 Hodman Murad · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for writing, podcasting, and media founders.