Support SQL-compliant behavior on eq_dyn, neq_dyn, lt_dyn, lt_eq_dyn, gt_dyn, gt_eq_dyn

[viirya]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

Part of #2568.

These comparison kernels behaves different with SQL semantics on NaN handling. By definition, NaN is not equal to itself. But NaN is equal to NaN with SQL semantics and NaN is larger than any other numeric values.

Describe the solution you'd like

Describe alternatives you've considered

Additional context