Dynamic querying in Quill

quill_dynamic_query.sc

import $ivy.`io.getquill::quill:2.6.0`
import io.getquill._

val ctx = new SqlMirrorContext(MirrorSqlDialect, Literal)

import ctx._

case class Entity(field1: String, field2: Int)

def getEntity(field1: Option[String], field2: Option[Int]) = {
  type QEC = Quoted[EntityQuery[Entity]]

  val initialQ: QEC = quote {
    query[Entity]
  }

  val field1Filter = field1.map(f1 => (q: QEC) => quote(q.filter(_.field1 == lift(f1))))
  val field2Filter = field2.map(f2 => (q: QEC) => quote(q.filter(_.field2 == lift(f2))))

  val activeFilters = Seq(
    field1Filter, field2Filter
  ).flatten

  val conQ = activeFilters.foldLeft(initialQ)((q, filter) => filter(q))

  ctx.run(conQ).string
}

println(getEntity(Some("foo"), None))
println(getEntity(None, Some(42)))
println(getEntity(Some("foo"), Some(42)))