After working with ORMs for a long time, all I really want is a nice API for building queries (that actually supports all underlying database features) and automatic mapping of the results to whatever objects/structs and primitives the language supports.
Everything else is IMO a bad layer of abstraction that will eventually bite you when you need to get closer to SQL.
Everything else is IMO a bad layer of abstraction that will eventually bite you when you need to get closer to SQL.