title: How do I specify column names in Liquibase when creating view?
body: <p>I have a database view which selects two columns from two different tables with the same name.</p>
  
  <p>For example generating a DDL for the view would generate the following: </p>
  
  <pre><code>create view MYSCHEMA.VPRODUCTS ("Name", "AlternameName"...) AS
  A.Name,
  B.Name,
  from  PRODUCTSA A&amp;#13;
  left join PRODUCTSB B&amp;#13;
  ...
  </code></pre>
  
  <p>When I run the command to generate a Liquibase change set, the SQL in the  tag only contains a select statement for the two columns and makes no distinction for the unique column name (i.e. "Name", "AlternameName").</p>
  
  <pre><code>&lt;createView viewName="VPRODUCTS "&gt;SELECT  &amp;#13;
  A.Name&amp;#13;
  ,B.Name&amp;#13;
  from PRODUCTSA A&amp;#13;
  left join PRODUCTSB B&amp;#13;
  ...
  </code></pre>
  
  <p>As a result, whenever I try to execute the change set Liquibase complains about duplicate entries for columns with the same name. </p>
  
  <p>I can fix this by adding SQL "AS" statements in the  tag, but I'd prefer if there was a better way to do this.</p>
  
  <pre><code>&lt;createView viewName="VPRODUCTS "&gt;SELECT  &amp;#13;
  A.Name&amp;#13;
  ,B.Name AS AlternateName &amp;#13;
  from PRODUCTSA A&amp;#13;
  left join PRODUCTSB B&amp;#13;
  ...
  </code></pre>
  
  <p>Is there an attribute or tag that would allow me to specify the column names when creating the view, or providing the raw SQL in the DDL?</p>