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

- Manual join queries use `'mode'` instead of `'type'` to specify the `JOIN` mode of a read query (imo the `Query`'s `'type'` attribute should be reserved to a CRUD action only).
- Set `'read'` as the default option for `Query`'s `'type'`.
- Fix some typos in fixtures.