[FEATURE] supports RENAME TABLE to move a table from one database to another

[mchades]

Describe the feature

supports RENAME TABLE to move a table from one database to another

Motivation

Currently, we only support renaming a table within the same database. However, some systems, such as MySQL (https://dev.mysql.com/doc/refman/8.4/en/rename-table.html), support renaming a table to move it between databases.

Describe the solution

Add a new change type like "moveToSchema" to the table change support.

Additional context

No response

[mchades]

@jerqi Can you help check how we should handle privilege if we want to support this operation？ thx

[jerqi]

For MySQL, You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table.

[jerqi]

For us, it must be the owner of the table and have the another schema create privilege.