New SQL functions

We’ve added support for two new SQL functions in this week’s release of our managed cloud.

regexp_matches

First up: regexp_matches (docs) to return multiple matching substrings from a regular expression

> SELECT regexp_matches('new Materialize SQL functions are here!', '(new|Materialize|SQL|functions)', 'g');

Output:

regexp_matches
---------------
{SQL}
{new}
{functions}
{Materialize}

reverse

Next up: reverse (docs) to reverse a string.

> SELECT reverse('materialize');

Output:

reverse
--------
ezilairetam