Is there any way to use lateral joins with knex.js? It seems to be the only solution to my specific issue, but knex.js lacks a .lateral or a way to set it via raw.
Is there any way to use lateral joins with knex.js? It seems to be the only solution to my specific issue, but knex.js lacks a .lateral or a way to set it via raw.
The only way would be through using .joinRaw.
Also, there is an open issue on GitHub regarding this topic https://github.com/knex/knex/issues/3732