title: R -- RJDBC not able to rename column in SQL select
body: <p>Using the RJDBC library seems like you can't rename the column in the SQL select.
  Anyone know a workaround for it?  I found this useJDBC4ColumnNameAndLabelSemantics=true for Db2, but not sure it can use it in R.</p>
  
  <pre><code>Select
  a.customer,
  b.customer as main_customer,  &lt;-- returns as customer not main_customer
  b.customer_email
  from customer a,
       main_customer b
  where a.customer_id = b.customer_id
  </code></pre>