title: play framework ebean RawSql paging
body: <p>Should it be possible to use Paging with a custom SQL ebean query?  For example, when I set up this query:</p>
  
  <pre><code>String sql =
            "SELECT   q.event_id              AS event_id,"
          + "         MIN(q.total_price)      AS price_min, "
          + "         MAX(q.total_price)      AS price_max "
          + "FROM     quote q "
          + "WHERE    q.quote_status_id = 2 "
          + "    AND  q.event_id IS NOT NULL "
          + "GROUP    BY q.event_id";
  
  RawSql rawSql = RawSqlBuilder.unparsed(sql)
          .columnMapping("event_id", "event.id")
          .columnMapping("price_min", "priceMin")
          .columnMapping("price_max", "priceMax")
          .create();
  
  com.avaje.ebean.Query&lt;salesPipelineRow&gt; ebeanQuery = Ebean.find(salesPipelineRow.class);
  
  ebeanQuery.setRawSql(rawSql);
  </code></pre>
  
  <p>...I can then call... </p>
  
  <pre><code>List&lt;salesPipelineRow&gt; list = ebeanQuery.findList();
  </code></pre>
  
  <p>...without any problems (i.e. I get back a valid List of salesPipelineRow objects).  However, when I instead try something like...</p>
  
  <pre><code>Page&lt;salesPipelineRow&gt; page = ebeanQuery.findPagingList(5).getPage(0);
  </code></pre>
  
  <p>...I get a null error such as:</p>
  
  <pre><code>java.util.concurrent.ExecutionException: javax.persistence.PersistenceException: 
  Query threw SQLException:You have an error in your SQL syntax; check the manual that corresponds to your MySQL     
  server version for the right syntax to use near 'null t0
  limit 6' at line 2
  Bind values:[]
  
  Query was:
  select t0.price_min c0, t0.price_max c1, t0.event_id c2
  from null t0
  limit 6
  </code></pre>
  
  <p>Can anyone explain why the FROM, WHERE and GROUP BY clauses are getting replaced by "null"?</p>
  
  <p>Thanks!</p>