Changelog

New SQL functions

03.27.2025

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

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

Output:

1
regexp_matches
2
---------------
3
{SQL}
4
{new}
5
{functions}
6
{Materialize}
text

reverse

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

1
> SELECT reverse('materialize');
sql

Output:

1
reverse
2
--------
3
ezilairetam
text