I was reviewing some of the "Interesting queries on Data Explorer", and saw that the top-voted answer, "How many users can do X?", was broken and obsolete. And, it only had data for Stack Overflow proper -- not any of the dozens of other sites or their metas.
I set about to revive, update, and broaden this query and quickly ran up against some problems:
- There is no table of Privileges in the SEDE data. There are tables of Privileges in the API, but that is not usable in SEDE.
- Trying to hand-create a table of privileges, like in this query, is not a good option, because of the need to constantly hand-check dozens of sites for changes. (Note that that query's table was based on just a sample of 6 sites and 6 metas.)
There is no way for a SEDE query to know what site's data it is operating on. That means that queries that depend on site-specific data have no way of delivering accurate and concise results. See this query, again, for example.
As Nick pointed out,
DB_NAME()is set to match the source site.
So, Please add a Privileges table to the Data Explorer. Which would return site-specific reputation requirements, just like the API does.