Except it explicitly is not strictly Boolean in SQL because of nulls.
X = Y can take the value true, false or null if either or both X and Y are null.