
as-of is not the same as current
a lot of warehouse bugs come from answering the wrong time question. i explain when you need an as-of result instead of the current row, and three patterns that keep the grain correct.
this series is where i write about sql as a working craft: clear queries, reliable debugging, and practical performance habits.
if a specific sql pain point keeps repeating in your work, send it to me and i will use it to shape upcoming entries in this series.

