有没有办法在代码中将一个巧妙的插补查询拆分到多行？我的查询往往会很长。

因此，我寻找类似以下内容的内容：

val query = sql"select * from DOCUMENTS " + 
            sql"where language = $lang order by publication_date desc"
query.as[ResearchDocument]

但这会导致

type mismatch;
 found   : scala.slick.jdbc.SQLInterpolationResult[String]
 required: String
          sql"where language = $lang order by publication_date desc"
          ^

推荐答案

好，看起来Scala三重引号字符串是可行的：

val query = sql"""select * from DOCUMENTS
                  where language = $lang order by publication_date desc"""