Add support for joining entities, using a specific join-type

[DTB01]

Currently, it is possible to specify a type (e.g. :inner) when doing a join with an explicit clause

(select "users" (join :inner "email" (= :email.users_id :id)))

When joining entities based on their relation as below, the type is defaulted to :left

(select users (join email))

And it is not possible specify a type, i.e. not possible to do

(select users (join :inner email))

I've enabled this and made the change so that the arglists look like so

[query ent]
[query type ent] ;new
[query table clause]
[query type table clause]

I believe this is very helpful as it allows us to join entities using an arbitrary join-type, without having to repeat the join constraints from the rels that we already defined in defentity.

[immoh]

Some things to fix before I can merge this:

• There are no tests that verify that correct sql is generated
• Docstring has args in wrong order
• Aren't changes to add-joins unnecessary?
• Squash commits (and rebase on latest master)

Thanks.

[DTB01]

Will fix tests and docstring. The extra type arg to add-joins seem necessary. Unless i am completely missing something here.....

Thanks

[DTB01]

Fixed docstring and added tests. Squashed and rebased.

Cheers

[immoh]

Thanks!