SQL is more of a data language, but things like T-SQL or P-SQL I guess count. Lots of programming languages interacting with SQL databases mistreat NULL values. This guy's plate should never be "IS NULL" but should be a string that "plate = 'NULL'".
I think it would be more the case that specific programs (or stored procedures) mistreat NULL values, rather than a language or library not providing a way to properly handle them.