BasicDoobieTable.scala

trait Persisted {
  def id: UUID
}

trait BasicDoobieTable[M <: Persisted] {
  def table: String
  def columns: Seq[String]

  implicit def composite: Composite[M]

  def insertColumns = columns.filterNot(_ == "id")
  def tableF = Fragment.const(table)
  def columnsF = Fragment.const(columns.map(table ++ "." + _).mkString(", "))
  def selectF = fr"SELECT" ++ columnsF ++ fr"FROM" ++ tableF

  def find(id: Long): ConnectionIO[Option[M]] = {
    (selectF ++ fr"WHERE id=$id").query[M].option
  }

  def findBy[A](column: String, value: A)(implicit meta: Meta[A]): ConnectionIO[Option[M]] = {
    (selectF ++ Fragment.const(s"WHERE $column=") ++ fr"$value").query[M].option
  }

  def list(): ConnectionIO[List[M]] = {
    selectF.query[M].list
  }

  def create(entity: M): ConnectionIO[Int] = {
    val placeholders = insertColumns.map(_ => "?").mkString(", ")
    val q = s"INSERT INTO $table (${insertColumns.mkString(", ")}) VALUES ($placeholders)"
    Update[M](q).run(entity)
  }

  def update(id: UUID, entity: M): ConnectionIO[Int] = {
    val placeholders = insertColumns.map(f => s"$f = ?").mkString(", ")
    val q = s"update $table set $placeholders where id = ?"
    Update[(M, UUID)](q).run((entity, id))
  }
}

FooTable.scala

object FooTable extends BasicDoobieTable[Foo] {
  val table = "foos"
  val columns =
    Seq("id", "bar", "baz")

  val composite = Composite[Foo]
}