Hi Klipfolio and community,
I've just confirmed with support that there's no way to do RegEx substrings in PostgreSQL queries.
This makes both Klip formulas unnecessarily complicated, and means that I am more limited in number of rows I can return due to the (very 2007-esque) 10MB limit on data sources.
Please implement (substring) RegEx support in PostgreSQL (and other SQL variants, if necessary).
Best regards,
Alexander