Compile-time Language Integrated Queries for Scala
If this still looks like too much hassle, you can always go a bit higher-level and use something like Quill, which is also a powerful approach that uses a different, more ORM-like style.
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.
Query DSL in Scala ?
1 project | reddit.com/r/scala | 24 Feb 2022
Scala, 2.12/2.13, which driver/library recommend for connecting to Cassandra
1 project | reddit.com/r/scala | 19 Jun 2021
[Debate] Is type level programming useful?
2 projects | reddit.com/r/scala | 28 Feb 2021
New to PostgreSQL - Best way to use it?
6 projects | reddit.com/r/PostgreSQL | 25 Jan 2022
Scala 3 RDBMS Libraries
1 project | reddit.com/r/scala | 10 Dec 2021