I think you're using it correctly, I am afraid it appears there is a bug in the serializer that ignores the applied limit and offset. Never fixed it in Querydsl, but TBH i'm not sure if JPA allows LIMIT/OFFSET in subquery expressions. I have to look that up. I know I did implemen...
It is right, the documentation means that the static factory needs to be used to obtain a subquery instance on which the subqueries FROM and WHERE clause can be set. If you need to use subqueries in the FROM clause in JPQL/JPA, check out the Querydsl integration for Blaze-Persistence: htt...