FYI I made a very simple library for a good customer to add EU accent-enabled UPPER and LOWER functions: https://github.com/brodybits/sqlite3-eu
It is possible to use the library to either add separate EU-enabled UPPER & LOWER functions, like UPPER_EU & LOWER_EU, or overwrite the existing UPPER & LOWER functions.
For the sake of Unicode folding beginners like myself, you should be able to do the case-insensitive LIKE condition in a statement like this:
SELECT rowid, name FROM t1 WHERE LOWER_EU(name2) LIKE LOWER_EU(?)