sea-query statements should qualify schema name

[nahuakang]

Motivation

Linked to sea-orm issue 521: sea-orm-cli migrate should respect the DATABASE_SCHEMA for Postgres in the specified in a project's .env file. This is currently not respected and the migration is done on the public schema.

Proposed Solutions

Update all statement types in sea-query to quantify the schema name for Postgres. Check all stmt in the link below and see if any table reference is of Iden type, it should be changed to TableRef.

Also, some statement support schema scope, for example, type name could have schema prefix e.g. in Postgres. We can update it from Iden to IdenList.

https://github.com/SeaQL/sea-orm/blob/183639dc8c817fbd3211a87c67bcb983db4050ed/sea-orm-migration/src/manager.rs#L37-L89

Additional Information

See discussion here

[billy1624]

Hey @nahuakang, let me know if you need help :)