You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@empire-db.apache.org by "Rainer Döbele (Jira)" <ji...@apache.org> on 2023/03/02 14:06:00 UTC

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

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)