Possibility to prepare joins manually

[wiktor-obrebski]

SqlDust help you with "joins specifications" and it's cool.
But you sometimes can't (or just don't want) modyfing your database to follow conventions used by SqlDust.

It would be nice to make this auto-joins optional and allow developer to specify joins manually - and simple way to make manual joins. Additionally it would cover lack of "LEFT/RIGHT/INNER" join options.

I would love it to looks like this:

select(["id", "state.name"])
 |> from("city")
 |> join_on("state", "state.id = city.stateId", "RIGHT")
 |> adapter("postgres")
 |> to_sql

# or

select(["id", "state.name"])
 |> from("city")
 |> right_join("state", "state.id = city.stateId")

We spoke about this on email and I can't wait to see this in SqlDust :)