index on regex

I see from the sqlite documentation you can index on a regex , is this possible in Xojo’s sqlite3 wrapper

SELECT * FROM foobar WHERE pattern REGEXP ‘foo.*’

etc

probably not

from SQL Language Expressions

pretty sure xojo does not add a user written regexp function to the build of sqlite

EDIT : OH But Thomas T did have a means to add user written C functions to the default sqlite from xojo
let me find it

EDIT : this - Views of a Coder: Xojo SQLite databases: Enabling ICU for full Unicode support and adding custom functions
dont think it adds a regexp though