As a tool for mapping query results to objects and doing crud, hibernate is fine. Certainly it is much better than writing your own hibernate on jdbc. Which you do eventually because everyone gets sick of typing the same boilerplate over and over.

I think you hit a few key points though - don't try to hide the database flavor and don't use JPQL (just write native SQL).