does labkey sql allow regular expressions? i did not see it in the documentation. i am trying to do the following:

species can be inferred from subjectID using pattern matching. I have a table with the columns Species and Pattern. I'd like to join this table to study.participant where the Id matches the pattern in the pattern column.

I could approximate this using a bunch of LIKE "r%"; however, using a true regular expression would make it much cleaner and more accurate. thanks.