Null-safe comparison: IS DISTINCT/NOT DISTINCT FROM

I've been working for surprisingly long with SQL to have found this only a few days ago. Not long enough I guess 🤓.

I'm talking about the NULL-safe operators IS DISTINCT FROM and IS NOT DISTINCT FROM. I found about their existence from a Linkedin post.

Works on BigQuery too, so I guess less need of adding IFNULLs / COALESCE for safety.

PS This choice of keyword "FROM", together with the one in EXTRACT(HOUR FROM DATETIME '2021-01-01'), feels pretty weird.

Found it useful? Subscribe to my Analytics newsletter at notjustsql.com.