> 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 whateve

> 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. For Java based solutions, check out https://www.jooq.org/ https://www.jooq.org/ or http://querydsl.com/ http://querydsl.com/