在JPA Criteria API中表达SQL查询太复杂了？

I have an SQL query that gets me exactly the data I need. The problem is that we are trying to express all queries in JPA Criteria API to maintain portability, and I can't figure out how to map this particular query.I have an SQL query that gets me exactly the da