Hibernate vs CFQuery

Question

CF9 recently released support for Hibernate. One thing I cannot understand is the differences between Hibernate and CFquery. Although I see that Hibernate is good for matching tables with objects and then calling objects like getTableName (), etc. But tell me if I want to replicate this request

SELECT SUM (tableVal) FROM mytable

Dont I still have to use HQL and invoke the query. If I do this, then why use sleep mode. it just looks like a different way, essentially getting the same data.

I am sure that 100,000% lacks the concept of BIG. If someone can spot the differences and point me to some resources, this will be awesome.

Thank you, Faisal Abid

Answer 1

HQL will work, basic SQL in cfquery will work anyway.

The power of Hibernate does not perform aggregate functions such as SUM () or AVG (), but object relationship matching (ORM).