Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for LATERAL joins #899

Closed
NikolayMetchev opened this issue Apr 30, 2020 · 1 comment · Fixed by #2095
Closed

Add support for LATERAL joins #899

NikolayMetchev opened this issue Apr 30, 2020 · 1 comment · Fixed by #2095

Comments

@NikolayMetchev
Copy link

Postgres has added support for LATERAL joins:
https://www.postgresql.org/docs/9.4/queries-table-expressions.html

Can we please add support for those types of join to exposed?

@damien-roche
Copy link

damien-roche commented Feb 8, 2022

@Tapac is this something you would accept PRs for?

I would really love support for this as would simplify a few of the queries I'm working on.

My plan would be to add a joinModifier to the JoinPart along with enum JoinModifier.LATERAL and then append the modifier here:

https://github.com/JetBrains/Exposed/blob/master/exposed-core/src/main/kotlin/org/jetbrains/exposed/sql/Table.kt#L215

I am, however, unsure of where best to pass the modifier.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants