Do you love Hibernate? If yes, why? Isn't 1+n problem mind boggling?

Question

So, I personally don't like Hibernate and like to have full control over my queries [or stored procedures]. What is the motivating factor for developers to use it? Considering you might end up investing your time debugging the query issues vs writing your own stored procedures in the first place.
The most common answer I get is "its immensely popular". But, does popular always mean good?

Answer 1

sharpdesigner
Hibernate is popular because it's solves many problems during the implementation like ORM: object relation mapping.
The most important Hibernate’s feature is mapping from Java classes to database tables (and from Java data types to SQL data types), but also to provides data query ( and retrieval facilities ). It is important that Hibernate generates the SQL calls and relieves keeping the application portable to all SQL databases, with database portability delivered at very little performance overhead. This feature can significantly reduce development time that programmer would have to spent with manual data handling in SQL and JDBC.
https://dzone.com/articles/15-reasons-to-choose-hibernate-over-jdbc

Answer 2

and thats the problem. it doesnt always generate good SQL calls. Moreover, for RDBMS, it is always recommended to use Stored Procedures to make things faster and under check. Hibernate doesnt play well with this. Yes, it reduce the development time by increasing the debug and troubleshooting time. There isnt any free lunches 😇