Hibernate 3x allows you to specify handwritten sql including stored procedures for all create update delete and load operations. A non zero value enables use of jdbc2 batch updates by hibernate eg.

Hibernate Quick Guide Tutorialspoint
Hibernate provides a powerful query language hibernate query language that is expressed in a familiar sql like syntax and includes full support for polymorphic queries.