How to make search case insensitive in Flask Sqlite?

Question

SQLite

This code searches case sensitive

ru_riddles = riddles.query.filter(riddles.ruText.contains(q)).all()

This code too, although it should search without case

ru_riddles = riddles.query.filter(riddles.ruText.like(q)).all()

If you replace just q with "%" + q + "%", nothing changes.
I tried to execute a query in DB Browser (SQLite) And even there it did not work . Is it possible to execute such a query in SQLite at all? Personally, I don't think so
SELECT * FROM riddles WHERE ruText LIKE "%текст%"

Answer 1

I understand you have sqlalchemy, try ilike , but I don't know if it works correctly with sqlite:

ru_riddles = riddles.query.filter(riddles.ruText.ilike(q)).all()

Answer 2

Known issue with SQLite