A better way to do Postgres case-insensitive searching?

[Jaymon]

Currently we basically do this but it is probably worth revisiting this and taking a good look at citext or collation (which is how we do it on SQLite).

Jarid was researching this in July 2022 for something on Bodega and is the one that showed me citext.