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

["Zkplo (via GitHub)" <gi...@apache.org>]

Zkplo opened a new issue, #11243:
URL: https://github.com/apache/inlong/issues/11243

   ### Description
   
   - parent issue #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?
   
   - [X] Yes, I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org