As a workaround, try leveraging RawSQL to pass-in functions that the data source supports (note that this will depend on what you wish to accomplish with the substring from the REGEXP function): Pass-Through Functions (RAWSQL).
Cause
Support for regular expressions is not currently built into Microsoft SQL Server.