[Feature][SDK] Transform SQL supports SUBSTRING_INDEX 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_substring-index

SUBSTRING_INDEX(str,delim,count): Returns the substring from string str before count occurrences of the delimiter delim. If count is positive, everything to the left of the final delimiter (counting from the left) is returned. If count is negative, everything to the right of the final delimiter (counting from the right) is returned.

Use case

SUBSTRING_INDEX('www.mysql.com', '.', 2);    -> 'www.mysql'
SUBSTRING_INDEX('www.mysql.com', '.', -2);   -> 'mysql.com'

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