I haven't used it heavily but one of our newer microservices uses Quill for read-only access to Postgres. I have found it to be great to work with, to combination of "just use case classes" and a DSL that feels like writing SQL is pretty nice.
Re:From First Principles: Why Scala?
by still_grokking on Saturday February 13, 2021 @05:31AM
(#26122741)
You can have Quill syntax for Doobie nowadays:
https://tpolecat.github.io/doobie/docs/17-Quill.html
That's by far the best DB access layer I've ever worked with.
Having said that I think Quill looks nicer (https://getquill.io/) if you want a DSL like that.