The commit f57ad42 reverted Breaking: Add LEFT() and RIGHT() SQL string functions to fix #590 (#2191)" f57ad42d as it was a breaking change and we are not ready to bump the major version.
This is to remember to reinstate the functionality when major version bum.