[Feature][SQL] Can support #{} similar to mybatis

[fuchanghai]

Search before asking

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

Description

Use case

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

[ruanwenjun]

Is there any advantage to use # rather than $? I don't think we need to deal with SQL injectionin sql task

[fuchanghai]

hi @ruanwenjun We now have a use case where the sql type node in the current process definition needs an output type variable declared by the subprocess definition that depends on the subprocess type node. This subprocess definition is referenced by many parent canvases. The advantage is that when we need to change, we only need to change the variable values in the subprocess definition, instead of changing all the canvases

[fuchanghai]

hi @ruanwenjun We now have a use case where the sql type node in the current process definition needs an output type variable declared by the subprocess definition that depends on the subprocess type node. This subprocess definition is referenced by many parent canvases. The advantage is that when we need to change, we only need to change the variable values in the subprocess definition, instead of changing all the canvases

We need to concatenate this sql statement using variables of the output type of the upstream node

[fuchanghai]

This function has been implemented，i will close this issue ,and add some documents