[Discuss][CDC] Support processing DDL change events

[hailin0]

Search before asking

• I had searched in the feature and found no similar feature requirement.

Description

SeaTunnel as CDC data synchronization, I think we need to support DDL change as a feature, I'm writing a draft design. and I want to hear from you all how you think it can be implemented in SeaTunnel.

Usage Scenario

No response

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[hailin0]

#4701

[hailin0]

DDL SQL Parser:

Antlr supported dialects：
https://github.com/antlr/grammars-v4/tree/master/sql

Calcite supported dialects：
https://github.com/apache/calcite/tree/main/core/src/main/java/org/apache/calcite/sql/dialect

Adapte debezium ddl parser：
https://github.com/debezium/debezium/tree/1.6/debezium-ddl-parser/src/main/antlr4/io/debezium/ddl/parser

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

[github-actions]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.

[hailin0]

Zeta engine adapter. #5125

[hailin0]

mysql-cdc connector adapter #6929