Support: IS DISTINCT FROM operator, IS NOT DISTINCT FROM operator, and COALESCE transform

[nizarhejazi]

• Supports COALESCE transform.
• Supports IS DISTINCT FROM operator.
• Supports IS NOT DISTINCT FROM operator.

Note: IS DISTINCT FROM is a transform function that can be rewritten as the following:

a IS DISTINCT FROM b 
-- equivalent to --
((a <> b OR a IS NULL OR b IS NULL) AND NOT (a IS NULL AND b IS NULL))

Nevertheless, it is a good idea to support these operators for two reasons:

1. To compute the end result more efficiently.
2. To simplify SQL query.
3. Presto supports it too.

[suddendust]

@Jackie-Jiang I can pick this up

[soupam05]

@Jackie-Jiang As this is open , can I pickup this?

[Jackie-Jiang]

The support was added in #9312 and #9327, then scalar function version added in #9486 and #9487. Closing this issue