Having done SQL development for a long time I think while that is technically correct in practice it causes too many issues and is a mistake. Many values in a

Having done SQL development for a long time I think while that is technically correct in practice it causes too many issues and is a mistake. Many values in a database are approximate especially if representing real world values, but in our logic we treat them as equal even if they really aren't exactly equal, because that's practical. At least GROUP BY / aggreagates treats null equal, this was done for practicality and is a special exception which drives home the point. In the end x == y OR (x IS NULL AND y IS NULL) simply wastes my time and adds no value to me along with the other issues that come with not simply allowing x == y checks like every normal programming language I use.