You can use native SQl those in cases where HQL lacks or degrade the performance. stack says: Limitations of HQL HQL Queries can not perform DDL operations HQL Queries Can not be used in PL/SQL Programming HQL Queries can not be used to insert Single record into table HQL Queries gives negligible performance degradation because Conversion(HQL to SQL) when compare SQL.