I'm surprised more people aren't recommending e.g. JDBI

https://jdbi.org/

I've used it on several projects and it seems to be the perfect balance between 'close to the DB' and 'close to the domain/application'.