When doing left outer joins, it would be a nice addition if you could use onKey() and add extra conditions (since you cannot alway put them in the where clause and get the same result).
Is there a way to do that or is it reasonably easy to implement or perhaps a workaround.
My current workaround is to do a regular .on() and provide the key columns manually.
I was thinking you could either have onKey() return and SelectOnConditionStep so you could do onKey().and(...), this will on be backwards compatible so perhaps a new method onKeyWith(). Or perhaps a way for a regular .on() to use the default keys as in .on(key()).and(...).
And thanks for a great product btw.
Best regards Jens