staticQuery.scala

    db.readOnly { implicit session =>
      val conn = session.conn
      val st = conn.createStatement()
      ...
      val sql =
        s"""
          select CONCAT(something, "-", other_thing, "-", YEAR(created_at))
          from some_table
          where created_at >= ${db.dialect.day(startDate)} and
                created_at < ${db.dialect.day(endDate)};
        """
      ...
    }