Join API

[WebFreak001]

the cross, left, right and full joins can be represented easily with this API:

db.select!LeftSide
    .leftJoin!RightSide((lhs, rhs) => rhs.reference.refersTo(lhs.id))

which would then make a select return value that returns a Tuple!(LeftSide, Nullable!RightSide)

the full return type table would be

Join Type	Return Type
Cross Join	Tuple!(LeftSide, RightSide)
Left Join	Tuple!(LeftSide, Nullable!RightSide)
Right Join	Tuple!(Nullable!LeftSide, RightSide)
Full Join	Tuple!(Nullable!LeftSide, Nullable!RightSide)