I personally prefer tools like https://github.com/jkk/honeysql

It helps build queries programmatically but doesn't abstract / get too much in your way.

On the "mapping" side, the resultset is just a map.

This is where languages that expose data-first shines