Lateral Left Joins in Drizzle Core Queries
I am creating a more complex Postgres query that requires me to drop down to the sql abstractions of drizzle (my query needs to use window functions and group bys). In this same query, I would like to return a column that includes a list of relations, ideally as a JSON array. My initial instinct was to try to recreate the lateral left join query, similar to how the drizzle query builder returns relations using the
However, in my reading of the documentation and the code, it doesn't appear that there is a way to access lateral left joins using the
I expect I might be able to write a subquery or a CTE in order to achieve this goal, but I was wondering whether there was anything I was missing/any way I could more easily replicate how drizzle achieves this goal?
Thanks!
withHowever, in my reading of the documentation and the code, it doesn't appear that there is a way to access lateral left joins using the
db.select()...lateralI expect I might be able to write a subquery or a CTE in order to achieve this goal, but I was wondering whether there was anything I was missing/any way I could more easily replicate how drizzle achieves this goal?
Thanks!
