Question

What is hql? how does it differ from sql? give its advantages?

Answer 1

Structured Query Language, also popularly known as SQL, is a database language that uses the concept of relational database management  to manage the data. The managing of the data includes select (retrieves the data from a single or multiple tables), insert (adds one or more rows in a table), update (responsible for changing the value of one or more rows in a table), delete (responsible for deleting one or more rows in a table) and schema creation through queries.

HQL, or Hibernate Query Language, extends the concept object-oriented programming to existing SQL. It is easy to learn and similar in syntax to SQL. It has features like aggregate functions and group by or order by clauses that you see often in SQL.