can I create common table expression (CTE) in custom query?

Hi

I wana use a complex query. I checked it on my databas on the server and it worked on the postgreSQL, but when I add it in the custom query on the BDM in Bonita Studio, it has an error:

30-Nov-2022 11:32:39.009 ERROR [http-nio-8080-exec-4] org.hibernate.internal.SessionFactoryImpl. HHH000177: Error in named query: MyTable.findQuery
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: with near line 1, column 1 [with myName as

It is possible to write complex query like this:

with myName as (
SELECT m.field, ....
sum(1) OVER () as total
FROM MyTable m
)

select * from myName