Intellij IDEA supports HQL auto completion and running HQL queries on console. This is how you enable that support.