> I won't push back on it being garbage, but I would suggest that if enough people did it that way it would be the new normal, and apologists would fall out of the woodwork
No. No-one would ever accept a database with _this_ level of brokenness. Like, this makes early Mongo and noughties-era mysql look _amazing_.
> I complain that mainstream SQL engines have no problem returning less than the total number of rows if you first query WHERE column = NULL and then query WHERE column <> NULL.
You may not like it, but that is entirely deliberate and internally consistent. Blame the people who came up with SQL in the 70s; far too late to change it now.