How does it handle operations more complex than "select * from user"? For example, joins and subqueries. And wouldn't it be nicer to have the database layer figure out properties for you instead of writing mapping code by hand?
For example (this uses SQL, I am not big on ORMs):
User user = database.queryForObject("SELECT * FROM user WHERE user_id=?", User.class, userId);