would that make sense to add ilike : infix fun<T:String?> ExpressionWithColumnType<T>.ilike(pattern: String): Op<Boolean> = ILikeOp(this, QueryParameter(pattern, columnType)) class ILikeOp(expr1: Expression<*>, expr2: Expression<*>) : ComparisonOp(expr1, expr2, "ILIKE")

Is this applicable only for PostgreSQL or any other databases?

It looks like by default MySQL is case insensitive for LIKE…

It depends on column collations and yes, default is

utf8_general_ci

which is case insensitive