[thehours]

Does 'pure SQL' have a specific definition (or reference spec)? The author doesn't mention it, except to say he tested it across Umbra, Postgres, and DuckDB. Even then, some days weren't 'supported by DuckDB due to a missing xor operator'.

[grumple]

There is an ISO spec (you have to pay for access): https://www.iso.org/standard/76583.html