11.4.2. HQL Statements

HQL allows SELECT, UPDATE, DELETE, and INSERT statements. The HQL INSERT statement has no equivalent in JPQL.

Important

Care should be taken as to when an UPDATE or DELETE statement is executed.

Table 11.8. HQL Statements

Statement Description
SELECT
The BNF for SELECT statements in HQL is:
select_statement :: =
        [select_clause]
        from_clause
        [where_clause]
        [groupby_clause]
        [having_clause]
        [orderby_clause]
The simplest possible HQL SELECT statement is of the form:
from com.acme.Cat
UDPATE The BNF for UPDATE statement in HQL is the same as it is in JPQL
DELETE The BNF for DELETE statements in HQL is the same as it is in JPQL