It would also be nice to add a section to the doc about this operator: https://datafusion.apache.org/user-guide/sql/operators.html#comparison-operators

However, we can do the docs as a follow on PR as well

Originally posted by @alamb in #14187 (review)