а в Hibernate in Action упоминается пара тулзов
их тестили ?

позябал pdf - впечатлило

7.2 Basic queries for objects
Let’s start with simple queries to become familiar with the HQL syntax and semantics.
Although we show the criteria alternative for most HQL queries, keep in
mind that HQL is the preferred approach for complex queries. Usually, the criteria
can be derived if you know the HQL equivalent, it’s much more difficult the
other way around.
NOTE Testing Hibernate queries—You can use two tools to execute Hibernate queries
ad hoc: Hibern8IDE, a Java Swing application; and an Eclipse plugin
called Hibernator. Both tools let you select Hibernate mapping documents,
connect to the database, and then view the result of HQL queries
you type interactively. Hibern8IDE even lets you prototype criteria queries
by providing a Java BeanShell. You can find links to both tools on the
Hibernate project web site.