title: How to reference the auto incremented id when performing a second insert in Liquibase?
body: <p>I am currently playing around with Liquibase and have created a table for users and a table for roles. Each user has a unique id which is auto generated (by a auto increment sequence) when a user is inserted. The roles in the role table are then referencing this id.</p>
  
  <p>Now I try to insert a default user using the Liquibase. First I insert the user and then I want to insert a role which is referring to this newly created user.</p>
  
  <p>The problem is that I can't find a way in Liquibase to retrieve which id was generated for the new user, so that I can use it when inserting the new role.</p>
  
  <p>Is this possible? If it is, how should it be done?</p>
  
  <p>Want to do something like following:</p>
  
  <pre><code>&lt;insert tableName="xxx_user"&gt;
      &lt;!-- Id is auto incremented --&gt;
      &lt;column name="user_name" value="XXX" /&gt;
      &lt;column name="password" value="XXX" /&gt;
      &lt;column name="first_name" value="XXX" /&gt;
      &lt;column name="last_name" value="XXX" /&gt;
  &lt;/insert&gt;
  
  &lt;insert tableName="user_role"&gt;
      &lt;column name="user_id" value="&lt;point at the auto generated id in previous insert&gt;" /&gt;
      &lt;column name="role" value="A_ROLE" /&gt;
  &lt;/insert&gt;
  </code></pre>