Case-Insensitive Search In Postgres

Hi.
I have setup a multi-query using complex conditions. One of those is a search filter, which uses “contains” operator.
But, the search executed on the DB is case sensitive. I searched for it and found that MySQL default to case insensitive search, but Postgres is csae sensitive.
To run case insensitive search, the query should look something like

SELECT subject FROM topics WHERE subject ~* 'eclipse';

Is there a way in Wappler to do this? The column part in conditions are dropdowns, so I can add a lowercase formatter there. Adding lowercase formatter just on the value part will not work either.
Please help.

Bump. @patrick

The query builder only supports generic queries, syntax that is supported by SQL standard and not custom database specific features. If you want to use database specific features like the one above then you should use a custom query.

Thanks for the reply.
Is there any other way to do a case-insensitive search using query builder?
I am not very familiar with PostgreSQL.

Please check this workaround