Compacting date intervals in BigQuery

Here's a practical BigQuery SQL exercise that highlights some important concepts as well is an interesting algorithm imho. I've pair programmed this with LLMs, if that's a thing 😎 Problem statement: compacting a SCD-2 table, essentially finding inte...