batch UPDATE

I am trying to figure out how to do batch update with doobie.
I have the following code snippet:

Update[?]( // What type to use here?
  s"""
     |UPDATE mytable SET
     |commitHash = tmp.commitHash
     |config = tmp.config
     |configScript = tmp.configScript
     |containerId = tmp.containerId
     |description = tmp.description
     |killScript = tmp.killScript
     |launchScript = tmp.launchScript
     |FROM
     | (SELECT
     | unnest(?) as commitHash,
     | unnest(?) as config
     | unnest(?) as configScript
     | unnest(?) as containerId
     | unnest(?) as description
     | unnest(?) as killScript
     | unnest(?) as launchScript
     | ) AS tmp
     | WHERE mytable.id = tmp.id;
     |""".stripMargin).updateMany((
  newRows.map(_.commitHash),
  newRows.map(_.config),
  newRows.map(_.configScript),
  newRows.map(_.containerId),
  newRows.map(_.description),
  newRows.map(_.killScript),
  newRows.map(_.launchScript),
))

This would eventually become part of a larger INSERT .... ON CONFLICT ... UPDATE statement. This approach was inspired by this stackoverflow answer. The trouble is that updateMany expects an argument of type F[A] where F is Foldable. This is not possible in my case because each of the ?'s might correspond to a scala list / sql array of a different type, e.g. suppose commitHash is an Int and all the rest are Strings.

It may be that this entire approach is misguided, but this answer from https://github.com/tpolecat/doobie/issues/193#issuecomment-459971953:

@letalvoj In postgres "upsert" is just an insert query with on conflict clause . You can write this query in doobie like any other query. What exactly do you mean by "native support"?

suggests that it should be possible to simply write an on conflict clause like this using doobie. Thanks!

Start with doobie's updateMany API and the PostgreSQL batch UPDATE and INSERT ... ON CONFLICT forms shown in the issue. Determine whether the differing Scala collection element types can be represented by the API, and document or demonstrate a supported approach for the requested batch upsert.