Using regex in virtual graph mappings from SQL source


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

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.