schema unique case insensitive

Suppose I have a table Clients and I want the name to be unique.
But, I want it to be case insensivive, normally I would use COLLATE NOCASE, but I couldn't find how to do that in drizzle.
Would love some help please.
Using sqlite.
Was this page helpful?