Alternatives to hibernate

What would be the best solution for programmers like http://vimeo.com/28885655

The people who created the video believe

1. In many cases hibernate is overkill
2. Basic sql is a good language that hibernate abstracts away to much

I heard about some other ORM implementations like

• https://github.com/rufiao/persist
• http://ormlite.com/
• http://www.simpleorm.org/

I would like to hear how they compare and what are the advantages/disadvantages of each one.