> Sometimes '=' is an identity test, sometimes it is `==`.

Eh... Where did you find `==` used in SQL?

DuckDB and some other analytical databases lets you do

    SELECT 2==2
But maybe that’s on them and not on SQL