In jOOQ:

        AUTHOR.ID, AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)
   .values(100, "Hermann", "Hesse")

In jOOQ:

   .set(AUTHOR.FIRST_NAME, "Hermann")
   .set(AUTHOR.LAST_NAME, "Hesse")

In jOOQ:

dsl.delete(AUTHOR)
   .where(AUTHOR.ID.equal(100))