Background

Currently, the schemadiff feature of the branch can compare whether the source_branch and target_branch in a certain workflow are the same. If they are different, it will print out the create table statements for each. However, there are more aspects to consider regarding schema difference.

Proposal

For example, we can add these features:

1. The comparison objects of the schema are not limited to just the source_branch and target_branch; a snapshot can also be included.
2. The granularity of schema comparison is not limited to the database; it can also be specified for a particular table.
3. The results of schema comparison: when the schemas are different, it can output the create table statements for each, or it can output the DDL statements needed to transform one schema into another.
4. Conflict detection: it can output whether there are conflicts between two schemas, i.e., whether the two schemas can be smoothly merged.