Custom query postgresql error!

Wappler 5.3.1
PostgrSQL 13
Node 14

have created a custom query using crosstab().
have already enabled tablefunc extension on DB Server.
have just one schema on the DB server that is called app.

upon running the query on dBeaver, it returns results as expected.
but when running the exact same query on Wappler via a custom query step, it throws error:
function crosstab(unknown, unknown) does not exist

image704×100 6.81 KB

please help here. looks like a Wappler bug!