Thorben Janssen from thoughts-on-java wrote a great post about usage of JPA in your next project. I highly recommend to read it fully. The original link could be found here Should you use JPA for your next project?.
Personally I like the opinion that ORM is not the best (right) tool to use it everywhere because you are familiar with it / love it. Thorben made an overview of usage not only Hibernate but also JOOQ, native SQL queries, stored procedures and so on. Also there is a great Q&A section. I've decided to make a diagram from that Q&A because I love diagrams!
And here is the result below: