Running queries to StackExchange Data Explorer from anywhere

Question

Now that we have an awesome tool StackExchange Data Explorer, won't its usefulness be multiplied manifolds if we could have a way of embedding queries onto a site that can fetch the results without the user having to actually go to the StackExchange website?

---

Something like this:

goes to

http://odata.stackexchange.com/stackoverflow/qt/5163/

select top 10 u.Id as [User Link], 
 (select sum(len(Body)) from posts where owneruserid = u.id) posts,
 (select sum(len(Text)) from comments where userid = u.id) comments,
 (select sum(len(Body)) from posts where owneruserid = u.id) +
 (select sum(len(Text)) from comments where userid = u.id) total
from users u
order by total desc

and produces the result

User Link        posts   comments total   
---------------- ------- -------- ------- 
Jon Skeet        6895871 1616661  8512532 
Marc Gravell     4454304 800243   5254547 
Alex Martelli    4018617 737938   4756555 
VonC             3688197 355679   4043876 
BalusC           3235636 740699   3976335 
Pascal Thivent   3298339 427297   3725636 
S.Lott           2473343 1177130  3650473 
paxdiablo        2870220 745320   3615540 
Jonathan Leffler 2663832 885100   3548932 
tvanfosson       2972126 564040   3536166 

(10 row(s) affected)

---

I am not an expert on web designing and might have not used the perfect language while describing this. So, if you find any technical faults with the question, please edit.

• Can this be done already?
• If not, what do you think about its usefulness?

Answer 1

Awesome Idea.

This can not be done yet but a patch is super welcome!

What I would really want is to have a way to embed stuff queries just like gist eg: <script src="http://gist.github.com/452054.js"></script> that way people can have a syntax highlighted runnable query embedded in their web page.