title: Jooq insert statement without code generation
body: <p>I am using jOOQ to generate SQL statements. How can I create an insert statement? I am able to generate a select statement, but I am unable to generate an insert statement. I can create a select statement like this:</p>
  
  <pre><code>String selectSQL = create.select().from("author").getSQL();
  </code></pre>
  
  <p>How can I create the SQL statement for insert</p>
  
  <pre><code>try {
          Class.forName("com.mysql.cj.jdbc.Driver");
          dbConnection = DriverManager.getConnection("jdbc:mysql://localhost:3306/library?autoReconnect=true&amp;useSSL=false","root","abcd");
          DSLContext create = DSL.using(dbConnection,SQLDialect.MYSQL);
           String SQl = create.insertInto(Table&lt;?&gt; table("author"), Field&lt;Object&gt; field("id"),Field&lt;Object&gt; field("first_name").Field&lt;Object&gt; field("last_name")).values("1", "askdfj", "kdjvk").getSQL();
  
      }
  </code></pre>