Support for polymorphic o2m/m2m relations (INNER_JOIN ... AND ...)

[phlisg]

Hello,

To avoid duplicated tables in the database or having redundant columns in the tables, I would like to know if it is possible to combine INNER_JOINs, something like that:

selectStmt := Foo.
    SELECT(Foo.ID, Bar.ID).
    FROM(
        Foo.INNER_JOIN(Bar, Bar.RelationableID.EQ(Foo.ID),
        Foo.INNER_JOIN(Bar, Bar.RelationableType.EQ("foo"),
    ).
   WHERE xxx

The target SQL I want to generate is this:

SELECT foo.id, bar.id
FROM foo
INNER_JOIN bar on (bar.relationable_id = foo.id) AND (bar.relationable_type = 'foo')
WHERE xxx

Is it possible?

[trevlt]

Do you mean AND in the join condition? Yes, of course:

selectStmt := postgres.
    SELECT(Foo.ID, Bar.ID).
    FROM(
        Foo.INNER_JOIN(Bar, Bar.RelationableID.EQ(Foo.ID).
                                           AND(Bar.RelationableType.EQ(String("foo"))),
        ),
    ).
   WHERE xxx

[phlisg]

Thank you for the answer 🙏