Generic deriving of a type-class that sets column values with JDBC, can derive for any arbitrary case-class (if you add a few more basic types)

generic-jdbc.scala

  import shapeless._
  import java.sql.PreparedStatement

  trait ToRow[A]{
    def toRow(a: A, statement: PreparedStatement): (Int) => Unit
  }

  implicit val stringToRow: ToRow[String] = new ToRow[String]{
    def toRow(s: String, statement: PreparedStatement) = statement.setString(_,s)
  }
  implicit val intToRow: ToRow[Int] = new ToRow[Int]{
    def toRow(s: Int, statement: PreparedStatement) = statement.setInt(_,s)
  }

  implicit val hnilToRow = new ToRow[HNil]{
    def toRow(s: HNil, statement: PreparedStatement) = (i: Int) => Unit
  }

  implicit def hconsToRow[H: ToRow, T <: HList: ToRow]: ToRow[H :: T] = new ToRow[H :: T]{
    def toRow(a: (H :: T), statement: PreparedStatement) = (i: Int) => {
      a match{
        case (h :: t) => {
          implicitly[ToRow[H]].toRow(h, statement)(i)
          implicitly[ToRow[T]].toRow(t, statement)(i + 1)
        }
      }
    }
  }
   
  implicit def caseClassToRow[C, R <: HList](implicit
    gen: Generic.Aux[C, R],
    rc: ToRow[R]
  ): ToRow[C] = new ToRow[C]{
    def toRow(c: C, statement: PreparedStatement) = rc.toRow(gen.to(c), statement)
  }