I agree you about JPA and we use JPA (Hibernate 3) for this purpose. these queries
that I have to run natively are about only 5% of all persistence layer but they are exist
and I can't find a way to run them with JPA/Hibernate. Now I am working on a solution
that someone suggessted on the web and if it was correct and helped I will tell about
that.