title: Clojure / Incanter Data Transformations Capabilities
body: <p>I'm considering Clojure / Incanter as an alternative to R 
  and just wondering if clojure / incanter have the capabilities to do the following:</p>
  
  <ol>
  <li>Import the result of a SQL statement as a data-set ( I do this in R using dbGetQuery ).</li>
  <li>Reshape the data-set - turning rows into columns also known as "pivot" / "unpivot"- I do this in R using the reshape, reshape2 packages ( in the R world it's called melting and casting data ).</li>
  <li>Save the reshaped data-set to a SQL table ( I do this in R using dbWriteTable function in RMySQL ) </li>
  </ol>