Not sure if loading SQLite extensions has become easier with Xojo now, but just in case, here’s a way to do it:
db.SQLSelect ("SELECT load_extension ("""+extFile.NativePath+""", ""sqlite3_icu_init"")")
The above is used to load the ICU extension (sqlite3_icu_extension.dylib
) so that you get unicode support for textual functions and comparisons.