For example JPOX was an ORM that almost put me off the entire idea. It was horrendous. Recently I've used Django ORM and SQLAlchemy - both are warty but genera

For example JPOX was an ORM that almost put me off the entire idea. It was horrendous. Recently I've used Django ORM and SQLAlchemy - both are warty but generally decent and better than not using any ORM. This is somewhat language dependent - certain language qualities inhibit the creation of decent ORMs (e.g. it's not really possible to create a decent ORM in golang due to its design).