是否可以动态构造jOOQ VALUES()表？

SELECT *
FROM (VALUES (1, 'John'), (2, 'Jane'), (3, 'Doe')) AS MyTable (ID, Name)

import org.jooq.*;
import org.jooq.impl.DSL;

import static org.jooq.impl.DSL.*;

public class JooqExample {
    public static void main(String[] args) {
        DSLContext dslContext = DSL.using(SQLDialect.MYSQL); // 替换为相应的数据库方言

        Table<Record2<Integer, String>> valuesTable = values(row(1, "John"), row(2, "Jane"), row(3, "Doe"));
        // 可以根据需要动态添加更多的值，例如：valuesTable = valuesTable.unionAll(values(row(4, "Smith")));
        
        Result<Record2<Integer, String>> result = dslContext.select()
                .from(valuesTable)
                .asTable("MyTable", "ID", "Name")
                .fetch();

        for (Record2<Integer, String> record : result) {
            Integer id = record.get("ID", Integer.class);
            String name = record.get("Name", String.class);
            System.out.println("ID: " + id + ", Name: " + name);
        }
    }
}