Cross Join support

[treadmillian]

Hi,

Is it possible to add CROSS JOIN support, like you've done with UNION and UNION ALL support?

Many thanks,
Kevin

[dave-redfern]

@treadmillian Hi, I recommend checking out the query-builder project instead and see if that better fits your needs. Depending on how you are creating the join it may be better handled via that project as it is a pure query builder / compiler instead of attempting to wrap DBAL. Yes there is more setup, but the builder is far more flexible and even better, until it is compiled, is completely editable as the state is kept as objects instead of casting to strings or intermediary structures.

My intention is to deprecate this project once the query-builder is sufficiently stable as the underlying DBAL usage does make adding SQL specific features much harder than it should be since it usually revolves around some form of string casting making it harder to keep the query editable.

[treadmillian]

@dave-redfern Thank you for the prompt reply. I'll certainly check the query builder project. Thank you 👍