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

[Jira]

Rainer Döbele created EMPIREDB-402:
--------------------------------------

             Summary: Allow Join definition using on(...) syntax
                 Key: EMPIREDB-402
                 URL: https://issues.apache.org/jira/browse/EMPIREDB-402
             Project: Empire-DB
          Issue Type: Improvement
          Components: Core
            Reporter: Rainer Döbele
            Assignee: Rainer Döbele


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)))}}

 

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)