...
Finally you can now use your real classes to construct queries and use the power of your IDE to maintain and validate your queries. http://torpedoquery.org/
2. Slick (Scala)
Scala Language-Integrated Connection Kit
Seamless data access for your Scala application — Write Scala code to query your database.
All database entities and queries are statically checked at compile-time.
Compose query operations just as if you were using Scala's collections. http://slick.typesafe.com/