The following are some of the reasons why HQL is preferred over SQL: Provides full support for relational operations. It is possible to represent SQL Queries in the form of objects in HQL which uses classes and properties instead of tables and columns. Return results as objects.

Which is better SQL or HQL?

In some cases it can happen Hibernate does not generate the most efficient statements, so then native SQL can be faster - but with native SQL your application loses the portability from one database to another, so normally is better to tune the hibernate mapping and the HQL statement to generate more efficient SQL ...

Is HQL faster than SQL?

SQL is usually faster than the non-native HQL, however, by setting the correct cache size of the query plan, HQL can be made to operate as fast as SQL.