I cannot emphasize enough how fucking awful the SQL standard's definition of isolation levels is. Ambiguous in like three different ways, and we've known it for 25 years. Every time I talk about an SQL database I have to explain the N different interpretations of the standard and show how a rules lawyer would try to defend batshit behavior. I cannot wait for it to be hurled into the sun and replaced with something that actually makes sense.