SQL uses [0] 3 valued logic, and most people seem to reason using 2-valued logic. So most people fund the behaviour of NULL, the 3rd logical value, to be weird.

> It's perfectly valid.

:o You'll get jumped on, saying this to a forum of software people. Lots of things that are valid are also weird.

[0] https://www.postgresql.org/docs/14/functions-logical.html