[Feature][SDK] Transform SQL support Concat_ws function

[MOONSakura0614]

Description

• parent issue [Umbrella] Tencent Rhino-bird: Expand InLong Transform functions #10796

CONCAT_WS(string1, string2, string3,…)

• Returns a string that concatenates STRING2, STRING3, … with a separator STRING1. The separator is added between the strings to be concatenated.
• Returns NULL If STRING1 is NULL.
• Compared with concat(), concat_ws() automatically skips NULL arguments.

Use case

concat_ws(’~’, ‘AA’, Null(STRING), ‘BB’, ‘’, ‘CC’) ---> “AA~BB~~CC”

Are you willing to submit PR?

• Yes, I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Hello @MOONSakura0614, thank you for opening your first issue in InLong 🧡 We will respond as soon as possible ⏳
If this is a bug report, please provide screenshots or error logs for us to reproduce your issue, so we can do our best to fix it.
If you have any questions in the meantime, you can also ask us on the InLong Discussions 🔍