title: SQL Objects API - Get all columns?
body: <p>I am using the SQL objects API in the following lines of code in my data access object to get the name field from a row in an SQL table where the ID matches the one provided.</p>
  
  <pre><code>@SqlQuery("select name from users where id = :id")
  String findNameById(@Bind("id") int id);
  </code></pre>
  
  <p>That works all well and good, but what on earth do I do if I want to return all of the fields for that row in the table, not just the name, but all colums for that record?</p>
  
  <p>I did try using :</p>
  
  <pre><code>"select * from users where id = :id"
  </code></pre>
  
  <p>But that isn't right, it only seemed to return the id field (possibly as it is the first column in the table, and my method returns a string?)</p>
  
  <p>Anyhow, I am all out of ideas on this and would appreciate all the help I can get.</p>
  
  <hr>
  
  <p>Additional Info as I get requests for information : </p>
  
  <p>This is the method signature of my method in the controller that calls my dao.</p>
  
  <pre><code>public String retrieveUserRecord(@PathParam("id") int id)
  </code></pre>
  
  <p>As you can see, it returns a string, as does the findNameByID method in the dao...</p>
  
  <p>What I want to do, is pass the id using my method signature, and get back all of my columns as one nice JSON object if possible?</p>