Support ON conditions that are not binary comparison predicates, e.g. BETWEEN, LIKE, IS NULL, IS [NOT] DISTINCT FROM, and boolean-expression predicates. These reach the join translator as predicate types other than ComparisonPredicate (or as ComparisonPredicate with DISTINCT_FROM/NOT_DISTINCT_FROM operators). They would require the lookup pipeline form with expr and per-predicate translation. Currently throws FeatureNotSupportedException. Split out from HIBERNATE-165 (which covers non-equijoin comparison operators lt lte gt gte ne). Addressing the source code notes tagged with TODO for this ticket is in scope.