This PR introduces support for the ilike operator in our application. The ilike operator is a case-insensitive version of the like operator, commonly used in PostgreSQL.
Changes:
The OperatorName type has been extended to include "ilike". This allows us to use the ilike operator in our application logic.
The KnexOperators constant has been updated to map the "ilike" string to "ilike". This ensures that the ilike operator is correctly translated when building queries with Knex.
A new ilike function has been added to the FunctionalOperators object. This function implements the logic for the ilike operator. It checks if the expected string starts with, ends with, or contains the actual string, taking into account the % wildcard character.
By adding support for the ilike operator, we can perform case-insensitive pattern matching in our queries, improving the flexibility and robustness of our application.
This PR introduces support for the
ilikeoperator in our application. Theilikeoperator is a case-insensitive version of thelikeoperator, commonly used in PostgreSQL.Changes:
The
OperatorNametype has been extended to include"ilike". This allows us to use theilikeoperator in our application logic.The
KnexOperatorsconstant has been updated to map the"ilike"string to"ilike". This ensures that theilikeoperator is correctly translated when building queries with Knex.A new
ilikefunction has been added to theFunctionalOperatorsobject. This function implements the logic for theilikeoperator. It checks if theexpectedstring starts with, ends with, or contains theactualstring, taking into account the%wildcard character.By adding support for the
ilikeoperator, we can perform case-insensitive pattern matching in our queries, improving the flexibility and robustness of our application.