[Tech Request]: Alter table add column or rename column NEEDs in-place modification.

### Is there an existing issue for the same feature request?

- [X] I have checked the existing issues.

### Is your feature request related to a problem?

Exec `alter table add column ...` or `alter table rename column ...` will trigger ops like:
1. rename origin table
2. create new table
3. insert into new_table as select * from origin_table.

### Describe the feature you'd like

Alter table add column and rename column should do NO-DATA-COPY op. In-place alter is required, especially for the giant table. If do copy-data op ON TiB size table, it cost hours to complete the op.

suggestion: schema version control. allows to `append` new column with default value.

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

_No response_

### Additional information

_No response_