index on regex

Databases
#1

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

#2

probably not

from https://www.sqlite.org/lang_expr.html

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 - http://blog.tempel.org/2015/09/xojosqliteextensions.html
dont think it adds a regexp though

#3