BC Break: Fix collision on `'type'` option for `Query`.
- Manual join queries must use `'mode'` instead of `'type'` to specify the type of `JOIN`.
- Set `'read'` as the default option for `Query`'s `'type'`.
Merge pull request #919 from jails/refactor/query-type-attr

BC Break (minor): Fix collision on `'type'` option for `Query`.