ilike substitute for mysql

hi, is it possible to do case insensitive like in mysql using drizzle? doing like(sql’lower(${table.column})’, value.toLowerCase()) is giving me an error like in the attached screenshot i also found some resource that suggests adding COLLATE UTF8_GENERAL_CI column definition, maybe that’s how i should be doing it? any help is appreciated!