scala - 如何将 Slick 内插查询拆分为多行？

Question

有什么方法可以将 Slick 内插查询拆分为代码中的多行？我的查询往往会变得相当长。

所以我寻找如下内容:

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"
          ^

Answer 1

好的，似乎 Scala 三重引号字符串是可行的方法:

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