I've made myself a little query on the stack exchange data explorer which gets a leader board for the top comments on the site, and the URL for the post that the comment was posted on.
This query could theoretically run on any of the sites without a problem - the only difference is the site's URL.
To generate the URL of the post, I use the following code as part of the
'http://stackoverflow.com/' + LEFT(pt.Name,1) + '/' + cast(c.postId as varchar) as [URL]
Now the only part of my query which won't work cross-site is the initial part of the URL, in this case
http://stackoverflow.com/ - is it possible to parameterise the URL of the site that the query was executed against in the Stack Exchange Data Explorer?
This would allow for such use of URLs inside the query whilst enabling the query to be run against different sites.