Allow joins to nest conditional statements

[bendrucker]

Raised in #668 (comment)

This should be possible:

.leftOuterJoin('accounts', function () {
    this
      .on('users.id', 'account.user_id')
      .andOn(function () {
         this.on('users.state', '=', 'NULL');
         this.orOn('users.state', 'accounts.state');
      });
  });

[gchauvet]

👍

[danielgindi]

It's weird that this still isn't implemented...

[tgriesser]

@danielgindi feel free to send a PR or failing tests. Otherwise it's still on my todo list

[mdaparte]

thumbs up!

[hotaru355]

👍

[kof3r]

Is there a chance this will get implemented any time soon? Would help me avoid a raw query... 😄

[nkint]

any news on this?

[shinux]

very helpful feature 👍