Quill Timestamp

import java.time.Instant
import io.getquill.{MappedEncoding, LowerCase, MySQLDialect, JdbcContext}
import io.getquill.context.sql.SqlContext
import java.util.Date

trait Encoders {
  implicit val instantEncoder = MappedEncoding[Instant, Date](i => Date.from(i))
}

trait Decoders {
  implicit val instantDecoder = MappedEncoding[Date, Instant](d => d.toInstant)
}

trait Quotes {
  this: SqlContext[_, _] =>
  implicit class TimestampQuotes(left: Instant) {
    def >(right: Instant) = quote(infix"$left > $right".as[Boolean])
    def <(right: Instant) = quote(infix"$left < $right".as[Boolean])
    def >=(right: Instant) = quote(infix"$left >= $right".as[Boolean])
    def <=(right: Instant) = quote(infix"$left <= $right".as[Boolean])
  }
}

case class User(id: Int, name: String, timestamp: Instant)

lazy val ctx = new JdbcContext[MySQLDialect, LowerCase]("ctx") with Encoders with Decoders with Quotes
import ctx._

val start = Instant.parse("2016-12-01T00:00:00.000Z")
val end = Instant.now()

val q = quote {
  query[User].filter(u => u.timestamp >= start && u.timestamp < end)
}

ctx.run(q)