Why 'WHERE x = NULL' Never Works in SQL (And What to Use Instead)

This isn't a bug in your query — it's SQL's three-valued logic doing exactly what it's designed to do. Here's how to actually filter for NULL.