假设我想对一个记录的单链表中的一些元素进行重新排序...
想到的方法是构建一个(previous, current) id元组数组，然后在UPDATE语句的FROM子句中取消嵌套。
也就是说，大概是这样的：

private fun updateCompositionElementOrdering(elementIdsInExpectedOrder: List<Int>) {
    val PREVIOUS_ELEMENT = DSL.field("previous_element_id", Int::class.javaObjectType)
    val CURRENT_ELEMENT = DSL.field("current_element_id", Int::class.javaObjectType)

    val previousAndCurrent = elementIdsInExpectedOrder.mapIndexed { i, currentElement ->
        val previousElementId = if (i == 0) null else elementIdsInExpectedOrder[i - 1]
        DSL.row(previousElementId, currentElement)
    }

    ctx
        .update(COMPOSITION_ELEMENT)
        .set(COMPOSITION_ELEMENT.PREVIOUS_COMPOSITION_ELEMENT_ID, PREVIOUS_ELEMENT)
        .from(
            DSL.unnest(previousAndCurrent).`as`(DSL.name("p"), PREVIOUS_ELEMENT.unqualifiedName, CURRENT_ELEMENT.unqualifiedName)
        )
        .where(COMPOSITION_ELEMENT.ID.eq(CURRENT_ELEMENT))
        .execute()
}

当然是private val ctx: DSLContext。
但这会导致：

jOOQ; bad SQL grammar [
    update "public"."composition_element"
    set
        "previous_composition_element_id" = previous_element_id,
        "modified_by_id" = ? 
    from
        unnest(cast(? as any[])) as "values" (previous_element_id, current_element_id)
    where "public"."composition_element"."id" = current_element_id
];

nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "any"

(this与jOOQ 3.17.4和Postgres 13.5一起使用）