QueryBuilder case insensitive like operation AEM 6.4
I have a JCR-SQL2 Query . And is being used by QueryManager to perform case insensitive search using lower() method. I want to do the same using QueryBuilder API. We are using aem 6.4 . and fn:lower-case(jcr:content/jcr:title) doesn't work.
SELECT * FROM[cq:Page] WHERE ISDESCENDANTNODE(path) AND
( lower([jcr:content/jcr:title]) LIKE '%vehi%' OR lower([jcr:content/jcr:title]) LIKE '%auto%' )
UNION
SELECT * FROM[cq:Page] WHERE ISDESCENDANTNODE(path) AND
( lower([jcr:content/jcr:description]) LIKE '%vehi%' OR lower([jcr:content/jcr:description]) LIKE '%auto%' )
UNION
SELECT * FROM[cq:Page] WHERE ISDESCENDANTNODE(path) AND
( lower([jcr:content/cq:tags]) LIKE '%vehi%' OR lower([jcr:content/cq:tags]) LIKE '%auto%' )
ORDER BY [jcr:content/cq:lastModified] desc
Any inputs are helpful