[Feature] automatic table creation feature is still not perfect

### Search before asking

- [x] I had searched in the [feature](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22Feature%22) and found no similar feature requirement.

### Description

Automatic table creation currently has the following issues
1、Unable to batch automatically create tables when full database synchronization fails
2. Automatic table creation can only accept table name, field, and field type and field comments, but cannot accept table comments, primary key settings, or partition settings
3. Automatic table creation cannot automatically add partitions based on the query
自动建表目前存在以下问题
1、无法整库同步时批量自动建表
2、自动建表只能传入表名、字段以及字段类型、字段注释，却无法传入表注释、主键设置、分区设置
3、自动建表无法根据query自动添加分区

### Usage Scenario

test scenario：
hdfs sink
maxcompute sink
jdbc sink
I guess many other sink maybe have same problem.

### Related issues

maxcompute sink table partitioning exception
maxcompute sink无法写入分区表

### Are you willing to submit a PR?

- [x] Yes I am willing to submit a PR!

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)