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

### 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_

Start by tracing the existing table rename change support and the implementations that handle table changes across database systems. Define how a moveToSchema-style change should behave for cross-database moves, then verify the behavior against the existing table-change tests and MySQL's RENAME TABLE semantics.

Written by the indexing model from the issue text.