Please add support for ILIKE

[mvysny]

Similar to the like operator, but case-insensitive. Could be implemented as-is by using the ILIKE SQL operator, or could be emulated by using the LOWER() SQL function: Persons.name.lower().like("foo%").

[KunMinX]

see documents
https://www.ktorm.org/en/operators.html

[mvysny]

Thank you so much, indeed the documentation mentions how to add support for the ILIKE operator. Switching to org.ktorm:ktorm-support-postgresql made the ILIKE operator available and it works well with H2. Thank you, this solves the problem for me.