HQL is Hibernate Query Language, it based on SQL and behind the scenes it is changed into SQL but the syntax is different. You use entity/class names not table names and field names not column names. It also allows many shorthands.
Intellij IDEA supports HQL auto completion and running HQL queries on console.
This is how you enable that support.