[Feature][seatunnel-transforms-v2][Sql] use the built-in visitor mode of `jsqlparse`

[Zhouwen-CN]

Search before asking

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

Description

I want to use the built-in visitor mode of jsqlparse
Rewrite the transform-v2 SQL module
I am doing this and have achieved some results

Usage Scenario

For better extendable

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]

What are his advantages? Or is there any problem now

@chen0623-bak

[Zhouwen-CN]

@hailin0
I uploaded some code and closed PR
Because I'm still developing

1. Visitor pattern has good extensions
2. Using the visitor pattern can reduce a large number of if statements
3. Using the same code to handle data, type, where, validate
4. Use OutputDataTypes,OutputFieldNames,OutputFields to save results and index

[Zhouwen-CN]

Can someone help me take a look
All tests for transformer-v2 have been passed and are basically usable
If there are any issues, I will modify them as soon as possible
It has certain advantages in extensions and performance

[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.