Using regex in virtual graph mappings from SQL source

Support
1

Hi!

How can I get a regex from an SQL source like

regexp_like(strleft(alias, 4), '[[:lower:]]{3}[[:upper:]]') IS TRUE
to work in SMS2?

2 things are in my way: REGEXP_LIKE and STRLEFT

2

Hi Oliver,

See my other reply regarding the sql.functions virtual graph option.

Also, mapping to the result of functions can lead to performance problems depending on how you query the virtual graph. This is detailed here and here. If this is necessary, you can consider caching or materializing the data.

-Paul