Fails with parser error for the syntax SUBSTRING(col FROM 1) **Reporter**: [Daniël Heres](https://issues.apache.org/jira/browse/ARROW-11543) / @Dandandan <sub>**Note**: *This issue was originally created as [ARROW-11543](https://issues.apache.org/jira/browse/ARROW-11543). Please see the [migration documentation](https://github.com/apache/arrow/issues/14542) for further details.*</sub>