Support of operator IS NOT DISTINCT

Why it matters

This feature introduces the <=> operator, which treats two values as equal if they are both NULL or have the same value, solving the problem of comparison involving NULLs. It provides a more accurate and intuitive way to compare nullable columns, enhancing query correctness and expressiveness.

How to use it

You can use the <=> operator in your SQL queries to compare two expressions with NULL-safe equality. For example:

SELECT * FROM table WHERE column1 <=> column2;

This will return true if both values are equal or both are NULL.