Join condition should allow non-equijoin expressions #659
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Currently datafusion explicitly disallows join conditions not looking like Col1 = Col2.
We should be more flexible by moving unsupported parts of the condition to a filter instead.
Describe the solution you'd like
Any expression that can't be in the join condition, should move to a filter.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
Add any other context or screenshots about the feature request here.