Companion

The default folding: LOWER(column) LIKE ? with a lowercased value, ILIKE on PostgreSQL, and the plain case-insensitive LIKE on MySQL, MariaDB and SQL Server, whose collations already ignore case. On the client side the value is lowercased.