search

ufoss-org / kotysa

The idiomatic way to write type-safe SQL in Kotlin
The Unlicense
121 stars 2 forks source link

Add support to contains ignoring cases #137

Closed guitcastro closed 10 months ago

guitcastro commented 1 year ago

added the .containsIgnoreCase operation.

pull-vert commented 1 year ago

Hi @guitcastro

This feature is indeed useful, I will try to find a correct right way to do it for every supported databases. PostgreSQL supports iLIKE operator, for others it seems like I can use UPPER(value) function. I'll have to add startsWithIgnoreCase and endsWithIgnoreCase as well.

guitcastro commented 1 year ago

In my case, ILIKE operator would work because I am using postgreqll. Using UPPER would work for most of the cases. I think we might add a "custom" operation where users can defined their own fragments of sql.

pull-vert commented 1 year ago

I will start simple at first :slightly_smiling_face:

pull-vert commented 9 months ago

Hi @guitcastro This feature is included in the latest 3.2.2 version that was released yesterday