[Feature][SDK] Transform SQL supports FIND_IN_SET function

[Zkplo]

Description

• parent issue [Umbrella] Tencent Rhino-bird: Expand InLong Transform functions #10796
• MySql Official Description: https://dev.mysql.com/doc/refman/8.4/en/string-functions.html#function_find-in-set

FIND_IN_SET(str,strlist): Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of N substrings. A string list is a string composed of substrings separated by , characters. Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. This function does not work properly if the first argument contains a comma (,) character.

Use case

FIND_IN_SET('b','a,b,c,d');    -> 2

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