title: Use alias for JOIN using JOOQ's SelectQuery
body: <p>I need to write query with nested select and join using JOOQ's SelectQuery:</p>
  
  <pre><code>    SELECT *
      FROM (select * from 
      "public"."parent" 
      order by "public"."parent"."setup_time" 
      desc limit 10 offset 0) as "parent1" 
      join "public"."child" 
      on "public"."child"."parent_id" = "parent1"."id" 
      where "public"."child"."name" = 'test'
  </code></pre>
  
  <p>So, I've written something like this:</p>
  
  <pre><code>SelectQuery&lt;ParentRecord&gt; subSelectQuery = context.selectQuery(PARENT);
  selectQuery.addJoinOnKey(CHILD, JoinType.JOIN, CHILD.PARENT_ID);
  </code></pre>
  
  <p>But it generates sql code like</p>
  
  <pre><code>join "public"."child" on "public"."child"."parent_id" =  "public"."parent"."id
  </code></pre>
  
  <p>How can I use alias <strong>parent1</strong> instead of full table name <strong>"public"."child"."parent_id"</strong>?</p>