[Feature Request]: Support CREATE/DELETE CDC SQL with internal SQL executor

[cpegeric]

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?

Internal SQL executor cannot run CREATE CDC SQL command.  API call and internal SQL executor support should be provided
.
e.g.

 CREATE CDC `__mo_index_cdc_cdctest_src_hnswidx` 'mysql://root:[email protected]:6001' 'hnswsync' 'mysql://root:[email protected]:6001' 'cdctest.src' {'Level'='table'};

Describe the feature you'd like

The API call and internal SQL executor should provide the same function as the CREATE/DELETE CDC SQL command.

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

Additional information

No response