"I feel like this is the sweet spot―give me a thin abstraction over SQL and do the gruntwork of converting domain entities to tables and vice-versa, but nothing else, thanks."
Something like iBatis/nBatis? (Haven't used this since 2004)
Something like iBatis/nBatis? (Haven't used this since 2004)
Query-builders make it easy to compose queries, leaning on your programming language to enforce syntactic correctness. When you're dealing with SQL directly, composition means string concatenation. A query builder gives you a data-structure that represents a query.
I think it's helpful to distinguish between query-building and object mapping when the "orm-vs-sql" thing comes up.