Comment by setr

You run into this issue any time you do a LEFT JOIN in sql and the field you care about is nullable.

The right side value could be null because it was missing, or because it was literally null. You resolve by checking the join key, and if that is itself nullable, you’re forced to introduce a sentinel