qb
qb copied to clipboard
support `cross apply` and `outer apply`
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: