Hacker News Reader

What about just plain old query() SQL i usually find the easiest vs. mucking around with pivot tables.

SQL is fine if you don't want to play with the data interactively - but that's the real benefit of Pivot Tables.

Things like drilling through, filtering/slicing, and then generating a graph, all in SaaS without having to run anything local.

Yes exactly, excel's Pivot tables and charts are more powerful.