https://lucidsoftware.github.io/relate/
Relate is a lightweight, blazingly fast database access layer for Scala that abstracts the idiosyncricies of the JDBC while keeping complete control over the SQL.
libraryDependencies += "com.lucidchart" %% "relate" % "<version>"val ids = Seq(1, 2, 3)
sql"SELECT email FROM users WHERE id in ($ids)".asMap { row =>
row.long("id") -> row.string("email")
}val id = 4
val email = "[email protected]"
sql"INSERT INTO users VALUES ($id, $email)".execute()