title: JOOQ mock result with mocked fields
body: <p>I'm writing UT's for a project that uses JOOQ library to query over SQL, and I need to mock the SQL response.</p>
  
  <p>I've tried following <a href="https://www.jooq.org/doc/3.0/manual/tools/jdbc-mocking/" rel="nofollow noreferrer">this manual</a>, however, we use JOOQ with pure SQL, meaning we don't have any predefined classes for Fields or Tables.</p>
  
  <p>My question is - how can I define the Result object, without providing a Field as parameter? or defining a mock field param?</p>
  
  <pre><code>        Result&lt;Record2&lt;Integer, String&gt;&gt; result = create.newResult(AUTHOR.ID, AUTHOR.LAST_NAME);    // replace the AUTHOR.ID and AUTHOR.LAST_NAME with some string for example
          result.add(create.newRecord(AUTHOR.ID, AUTHOR.LAST_NAME));
          result.get(0).setValue(AUTHOR.ID, 1);
          result.get(0).setValue(AUTHOR.LAST_NAME, "Orwell");
          mock[0] = new MockResult(1, result);
  </code></pre>
  
  <p>I noticed that I can define a new field, but the interfaces that Field implements are quite extensive, so I'm looking for something simpler.</p>
  
  <p>Thanks! </p>