title: JOOQ: fetch single row by primary key?
body: <p>I have a primary key value and I want to fetch a record for updating, so at the moment I write:</p>
  
  <pre><code>AccountRecord account = db.selectFrom(ACCOUNT).
    where(ACCOUNT.ID.eq(identity.getAccountId())).fetchSingle();
  </code></pre>
  
  <p>JOOQ knows about the primary keys of my tables (such that it generates <code>onKey()</code> methods etc.) - so I was hoping for something like:</p>
  
  <pre><code>AccountRecord account = db.fetchByKey(ACCOUNT, identity.getAccountId())
  </code></pre>
  
  <p>But that doesn't seem to be a thing.
  Is there a more concise way of using the JOOQ API to do what I want?</p>