[EMPIREDB-402] Allow Join definition using on(...) syntax

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Core
• Assignee: Rainer Döbele
• Reporter: Rainer Döbele
• Created: 02/Mar/23 14:05
• Updated: 13/Apr/23 08:40
• Resolved: 13/Apr/23 08:40

Description

The definition of joins so far requires the provision of a comma separated list of columns or compare expressions which is unintuitive especially for complex join expressions with multiple conditions.

Hence, as an alternative, the sql "on" keyword should be offered to define a join.

e.g. the current expression:

.joinLeft(MODEL.ID, SALES.MODEL_ID, SALES.YEAR.is(2021))

can alternatively be written as:

.joinLeft(MODEL.ID.on(SALES.MODEL_ID).and(SALES.YEAR.is(2021)))