Explicit JOINs like in ActiveAndroid

[PtiPingouin]

How to perform an inner join?

[gfx]

How about direct associations?

[PtiPingouin]

I don't want to add columns to my models only to perform a join. I managed to do it with a raw query, but that would be great to have a built-in method in the future, like in ActiveAndroid.

Maybe something like:

selectFromMyModel().innerJoin(myOtherModelRelation).on(clause, args).where(...)...