[Improve][SDK] Enhance the functionality of the substring function in Transform SQL

[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

SUBSTRING(str,pos) = SUBSTRING(str FROM pos),
SUBSTRING(str,pos,len) = SUBSTRING(str FROM pos FOR len)
However, currently only SUBSTRING(str, pos) and SUBSTRING(str, pos, len) have been implemented.

InLong Component

InLong SDK

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