Add support for simple non-equi joins

For clarity, it might be better to iterate over `comparisonTypes` since it's more "neutral"