[Improvement][python] sql type can not be specified

[hiSandog]

Search before asking

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

Description

When I deploy sql task through python-gate.
Sql type will be identified by the regex.
I think it should be specified by a parameter.

当我通过python gate 上传一个 sql 类型的任务时
sql 的类型(SELECT / NOT_SELECT) 只能通过正则确定
应该通过一个参数指定更加直观一点

Use case

I can't create table task through python-gate.
Because the "create table xxx" sql will be identified as "SELECT" type.

当我想弄一个 创建表 的sql任务，它会被认定为 "SELECT" 类型，会导致任务失败，因为 正则表达式 是
"^(?!(.* |)insert |(.* |)delete |(.* |)drop |(.* |)update |(.* |)alter ).*"

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

[github-actions]

Search before asking

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

Description

When I deploy sql task through python-gate.
Sql type will be identified by the regex.
I think it should be specified by a parameter.

When I upload a sql type task through python gate
The type of sql (SELECT / NOT_SELECT) can only be determined by regular
It should be more intuitive to specify through a parameter

Use case

I can't create table task through python-gate.
Because the "create table xxx" sql will be identified as "SELECT" type.

When I try to make a sql task that creates a table, it will be recognized as "SELECT" type, which will cause the task to fail because the regular expression is
"^(?!(.* |)insert |(.* |)delete |(.* |)drop |(.* |)update |(.* |)alter ).*"

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

[github-actions]

Thank you for your feedback, we have received your issue, Please wait patiently for a reply.

• In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
• If you haven't received a reply for a long time, you can join our slack and send your question to channel #troubleshooting