Allow querying of migration status by user who cannot create a table

[aturleyIdeem]

We have a use case where we would like to allow a database user who CANNOT create a table to run Migrator::get_pending_migrations() to check to see if there are any pending migrations in a MySQL database. But this causes Migrator::install(), which runs CREATE TABLE IF NOT EXISTS seaql_migrations, which fails because the user does not have CREATE TABLE permission.

I recognize that this might be a bit outside of the standard use case for SeaORM, but it would be nice to be able to use a read-only user for what, on the face of it, would seem to be a read-only operation.

[ptdecker]

I'd like to second this concern. In many large organizations, DDL actions (CREATE, DROP, etc.) are restricted to other administrative teams and a separation is enforced. I have no expectations that a GET action (get_pending_migrations()) would have a side-effect of actually trying to CREATE a table.

[tyt2y3]

Fixed in #3144

[ptdecker]

Thank you for addressing this and for doing it so promptly!