A modern programming language that makes developers happier.

kotlinlang

Are there any plans implementing postgres `with` queries (CTE) in exposed DSL?

Hi <@U04T2DSE0T0> Here's the ticket for CTE support: <https://youtrack.jetbrains.com/issue/EXPOSED-868/Add-support-for-CTE-common-table-expressions|EXPOSED-868>. Please consider upvoting and joining the discussion there if you'd like. It's certainly a feature very much on our radar, but the ETA to implement it is not immediate.

In the meantime, there are custom solutions available:
• A more <https://gist.github.com/SalomonBrys/61fed3a1206d50e9865c3e76f274296b|comprehensive solution> from the ticket above
• A simpler <https://github.com/bog-walk/bootrack/blob/main/backend-jdbc/src/main/kotlin/dev/bogwalk/bootrack/backend/repository/custom/WithCTE.kt|basic fallback>