title: In JOOQ how do we use Java Instant to map to Postgresql's timetamp type?
body: <p>I was rather surprised to find out that JOOQ (as of 3.16) binds timestamp to LocalDateTime.  In my mind timestamp is most naturally mapped to an Instant, it is a Unix epoch timestamp.</p>
  <p>So how can we get JOOQ to generate  code that uses Instant instead of LocalDateTime?  Do I need to use a force generator?</p>
  <p>I tried using forced type like this but it never picks up my forced type.</p>
  <pre><code>                            .withForcedTypes(
                                      new ForcedType()
                                              .withUserType(Instant.class.getCanonicalName())
                                              .withConverter(com.monsolei.data.InstantConverter.class.toString())
                                              .withIncludeExpression(&quot;timestamp&quot;)
                              )
  </code></pre>