DSL.unnest(Collection) doesn't work on PostgreSQL

[lukaseder]

This query doesn't work on PostgreSQL, when inlining bind variables:

Integer[] values = { 1, 2, 3 };

Result<Record2<String, Integer>> r3 = create
    .select(
        val("a"),
        columnValue)
    .from(unnest(asList(values)).as("x"))
    .fetch();

This is because the Integer[] array component type information is lost when passing a List<Integer> to unnest(), so jOOQ generates

cast('{"1","2","3"}' as any[])

I cannot think of a thorough fix. PostgreSQL arrays need an array type, and any[] is not supported in SQL (it is in pgplsql, I think). So a reasonable thing to do might be to pick the array type from the first element, hoping there is such a first element.