Use case: find all nodes that haven't been tagged with a taxonomy term or all users that haven't filled out a new field on their user account, etc.
Would it be terrible to add an isNull isNotNull method that pass through to the SelectQuery by default? Would that interfere with other storage backends that don't support is null?
Note: the issue is full of SQL-bound broken hacks. Ignore them.