How to do a lowercase string comparison in druid sql

i want to do something like:

SELECT * WHERE LOWER(name)=‘john’

but it doesnt seem to be allowed.

what is the right way to achieve the above?

ahh turns out that way does indeed work. i was doing something different incorrectly.

Yup, you got it. Pro tip: same thing works with LIKE