qb icon indicating copy to clipboard operation
qb copied to clipboard

support `cross apply` and `outer apply`

Open davidAtInleague opened this issue 1 year ago • 0 comments

MSSQL Server and Oracle both support cross apply and outer apply as part of their join grammars, it would be helpful if QB offered a way to access these DB features.

An inbuilt qb.{cross,outer}Apply(...) method would be great. Alternatively a way to do something like pushRawJoin("cross apply ...") where pushRawJoin is strawman for "add the following arbitrary text into the generated sql while emitting joins" is a possible solution (issue that also discusses an 'add arbitrary sql text into specific statement positions' as a solution: https://github.com/coldbox-modules/qb/issues/170)

An attempt, mostly a proof of concept, at adding specific {cross,outer}Apply methods is at https://github.com/coldbox-modules/qb/pull/253

Misc. vendor info:

davidAtInleague avatar Jun 02 '23 14:06 davidAtInleague