Hibernate provide option to execute native SQL queries through the use of SQLQuery object. Hibernate SQL Query is very handy when we have to execute database vendor specific queries that are not supported by hibernate API. For example query hints or the CONNECT keyword in Oracle Database.
For normal scenarios, hibernate SQL query is not the recommended approach because we loose benefits related to hibernate association and hibernate first level cache.