[CAY-2526] Dynamic join at query time in ObjectSelect

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 5.0-M2
• Component/s: Core Library, Database integration
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 06/Feb/19 09:01
• Updated: 13/Jun/24 12:06

Description

For complex queries there is a need to join tables that are not directly linked with root via relationship.
Currently this can be done only in raw SQL queries (like SQLTemplate).

We can introduce support for that in ObjectSelect.

API can look something like this (we probably need some improvements in Property API as well):

StringProperty<String> paintingTitle = PropertyFactory.createString("p.paintingTitle", String.class);
ObjectSelect
    .columnQuery(Artist.class, Artist.ARTIST_NAME, paintingTitle)
    .join(Painting.class, "p", Artist.ARTIST_NAME.length().eq(paintingTitle.length()))
    .select(context);

Issue Links

• is required by: CAY-2528 Subquery as query root