Enhancement: Consider the ToLower() and ToUpper() in the Query Tree Expression.

[mikependon]

There is a user that reported that ToLower() (or ToUpper()) is not working in the Query Tree Expression like below.

connection.Query<T>(c => c.ColumnName.ToUpper().Contains("A"));

The expression above is failing.

The expected SQL statement would be like this.

WHERE (UPPER(ColumnName) LIKE '%A%');

In SQL Server, we do not need to do this, however, PostgreSQL is case-sensitive at it requires as transformation.

[mikependon]

FYI: @bfallar3

[not-authorized]

Any updates on this issue?

[mikependon]

The initial object based fix for this is now available on version RepoDB v1.12.8.

[mikependon]

You can now use the following Query Fields.

• LeftQueryField
• RightQueryField
• LowerQueryField
• UpperQueryField
• LeftTrimQueryField
• RightQueryField
• TrimQueryField
• LenQueryField/LengthQueryField