In ClojureQL how can I make a where clause case insensitive?

182 Views Asked by At

In ClojureQL how can I make a where clause case insensitive? I am trying to add UPPER or something to do this in the where clause but I can't figure out how to do this

1

There are 1 best solutions below

1
On BEST ANSWER

In ClojureQL you can call a function like this:

:function/col

So something like this should work according to the documentation:

(select (table :users) (where (= :LOWER/name john)))