Earlier this month I set up some test infrastructure using @pointfreecoPoint-Free's SQLiteData that uses SQL's query plan and explanation stuff (well, Claude did because I didn't know it existed) for snapshot testing my queries. Now I know if an index stops being applied, or if vm steps, sorts, table scans change.

It's been quite revealing to see how what I would assume are unrelated changes impact the amount of work that SQL has to do, and I feel like I've learned quite a bit in the process.