Improve Result / Record construction API

[lukaseder]

Currently, when constructing Result types (e.g. for the mock API), something like the following logic has to be used:

Field<Integer> key = DSL.field("key", Integer.class); 
Field<String> value = DSL.field("value", String.class);

Result<Record2<Integer, String>> result = create.newResult(key, value); 
result.add(create.newRecord(key, value)); 
result.get(0).setValue(key, 1); 
result.get(0).setValue(value, "1"); 
result.add(create.newRecord(key, value)); 
result.get(1).setValue(key, 2); 
result.get(1).setValue(value, "2"); 
mock[0] = new MockResult(2, result);

This is rather cumbersome and repetitive:

• The columns have to be specified many times
• All setters return void and cannot be chained

Something like this would be much better, conceptually:

mock[0] = new MockResult(2,
    create.newResult(key, value)
          .withRecord(1, "1")
          .withRecord(2, "2")
);

The above example is not possible from a generic type safety perspective - but another solution may be.

[lukaseder]

I didn't find a better solution for this API in all these years. Closing as won't fix