Kibana alternative for advanced graph / aggregation table

I have struggled a lot in the past due to limited plots and limited aggregation (kibana 4 beta 2) in kibana

. I wanted to "transform select sum(Col1 + Col2), Col3 from Table group by Col3 Order by Col3 desc

". I was able to convert the above request to a json request form. But I couldn't translate it into graphical view or pivot table.

So, could you please suggest alternatives kibana

where these requests or custom json reqeust can be presented?