From pen 3. + use dynamicQuerySchema[Person]("Person") dynamic-query-api
import io.getquill.{Literal, MirrorSqlDialect, SqlMirrorContext}
final case class PersonId(value: Int) extends AnyVal
final case class Person(
id: PersonId,
firstName: String,
lastName: String,
birthDate: LocalDate)
val context = new SqlMirrorContext(MirrorSqlDialect, Literal)
val person = "Person"
val person2 = "Person2"
import context._
val personContext = dynamicQuerySchema[Person](person)
val person2Context = dynamicQuerySchema[Person](person2)
val query = translate(personContext.filter(_.id == lift(PersonId(1))))
val query2 = translate(person2Context.filter(_.id == lift(PersonId(1))))
println(s"$query")
println(s"$query2")
Output
SELECT v0.id, v0.firstName, v0.lastName, v0.birthDate, v0.addressId FROM Person v0 WHERE v0.id = 1
SELECT v0.id, v0.firstName, v0.lastName, v0.birthDate, v0.addressId FROM Person2 v0 WHERE v0.id = 1
source
share