Filter with case insensitive in SQLite

[diegocgaona]

I want to filter records on a SQLite DB without case sensitive, but I didn't found a solution, it works fine if I filter with the correct case.

I'm using the filter like this:

await responseschema.from_queryset(
                model.filter("name"="name on record").all())

I found this:
https://stackoverflow.com/questions/973541/how-to-set-sqlite3-to-be-case-insensitive-when-string-comparing

And in SQLite an case insensitive filter could be used like:
SELECT * FROM ... WHERE name = 'someone' COLLATE NOCASE

The COLLATE NOCASE is the option I need. It's possible with Tortoise?

Any help would be appreciated.

Thanks!