I have had poor experiences with "fancy" SQL libraries in multiple languages. This includes Slick and Quill in Scala. I don't remember what the problems were w

I have had poor experiences with "fancy" SQL libraries in multiple languages. This includes Slick and Quill in Scala. I don't remember what the problems were with Slick that leave such a bad feeling when I hear its name -- that was 5 years ago -- but I had problems with Quill just last year. I was trying to use it to generate an efficient "in" query against a two column composite primary key, and nothing seemed to work. Since it uses macro magic, one of my attempts triggered an internal compiler error instead of normal compiler feedback. I ended up dropping Quill for ScalikeJDBC: http://scalikejdbc.org/ http://scalikejdbc.org/ It seems to be less popular/active than other libraries, but it is dead simple to use, even for developers new to Scala. I write exactly the SQL I want just like I would in psql. There is little-to-no magic. I think that the only slightly magical feature I use is variable interpolation into SQL ("SQLInterpolation") that prevents injection attacks. It actually has capabilities to automatically map tables/columns into different structures and generate code for you, but my team doesn't use any of that. We just write SQL.