How can we specify COLLATE on the schema?

There is a feature request here: https://github.com/drizzle-team/drizzle-orm/issues/638 For adding support for COLLATE to the schema. This seems like a fairly simple feature request, but very useful, especially for case insensitive queries. How can we get it on the roadmap?
GitHub
[FEATURE]: Support setting collation of columns · Issue #638 · driz...
Describe want to want Another fun Postgres feature! Let's say you're using fractional indexing and want to sort strings in a particular way that has nothing to do with their ordering in Eng...