xmysql now supports 
  + group by
  + group by, order by
  + aggregate
  + single file upload, multiple file upload and download file
  + where clause on list of resource
  + where clause on list of nested resource

https://github.com/o1lab/xmysql