feat: add queryInterface.withoutForeignKeyChecks, sequelize.destroyAll

[ephys]

Pull Request Checklist

• Have you added new tests to prevent regressions?
• If a documentation update is necessary, have you opened a PR to the documentation repository?
• Did you update the typescript typings accordingly (if applicable)?
• Does the description below contain a link to an existing issue (Closes #[issue]) or a description of the issue you are solving?
• Does the name of your PR follow our conventions?

Description Of Change

I needed a way to delete all rows from all tables between tests for #15840. TRUNCATE is not a viable solution when the table is referenced by other tables (even if they're empty) in some dialects.

This PR:

• Adds the ability to skip foreign key checks in sequelize.truncate for mysql, sqlite, mariadb via the a option: withoutForeignKeyChecks
• Adds a new method on queryInterface: withoutForeignKeyChecks, which can be used to temporarily disable foreign keys for a given connection.
• Adds sequelize.destroyAll which can be used as an alternative to sequelize.truncate, as it can handle foreign keys.
• Replaces internal uses of a few deprecated APIs, like Model.tableName
• Makes transaction.connection hard private with a getter
• Updates setTransactionFromCls to make it synchronise the transaction and connection parameters when possible. This makes designing APIs that use these two easier. You can now specify both as long as they are compatible.
• Replaces our test utils disableDatabaseResetForSuite & enableTruncateDatabaseForSuite with setResetMode

TODO

• add tests
• change the suite reset hook to have one hook that accepts multiple modes: delete-schema, truncate, destroy and none
• Implement Add the ability to re-use the same connection (sequelize.withConnection((connection) => {})) #15388