sqlkata / querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
https://sqlkata.com
MIT License
3.08k stars 498 forks source link

[Breaking Change] string WhereX methods should not use the LOWER method by default #610

Open ahmad-moussawi opened 1 year ago

ahmad-moussawi commented 1 year ago

Currently SqlKata will try to apply a case insensitive operation, for WhereString operations, for example this query

var query = new Query("Car").WhereLike("Name", "AM");

will get translated to

SELECT * FROM [Car] WHERE LOWER([Name]) like 'am'

What requested is to keep the default behavior of the database, and only apply the transformation if explicitly needed

Acceptance Criteria: