[freeman478]

I like using what is sometimes called Micro-ORM. Basically it does the mapping of query results to objects and sometimes has a basic query builder but you mostly use raw sql.

Dapper (https://github.com/StackExchange/Dapper) is a great one for .NET.

[signal11]

JDBCTemplate would probably also qualify, it can be useful especially if you use Spring already. JDBI can be an alternative if you don't use Spring.