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'`.