There are a number of tags for SQL key words. And I think that makes sense, mostly. However, many of those keywords are not very selective or descriptive by themselves as they are very common words. As SO grows, many of them are competing with other fields. I started editing a new tag wiki on sql-limit, but now I wonder how deep the rabbit hole goes.
List of candidates
with-clause x 8
where × 567
where-clause × 613
group-by × 2353
groupby - synonym of above
having × 138
having-clause × 44 - proposed synonym
distinct × 874
distinct-on × 7 - possibly merge candidate for the above
union × 1044
union-all × 64 - possibly merge candidate for the above
intersect × 99
except × 47
order-by × 1504
orderby - synonym of above
limit × 1001
limit-clause × 2
is to create (at least) the following tags and make
all some of the above (possibly more) synonyms.
I only picked the ones where I found a tag already. Feel free to edit if you agree with the general direction.
All of them shall get their tag wikis in a similar fashion, to give them a common appearance. Like, all excerpts should start with "SQL clause". Maybe with a brief example query in the tag wiki highlighting the keyword.
sql-limit can serve as prototype to illustrate that.
Would be done in three steps:
- Create the new tags - maybe rename some in existence?
- Retag where appropriate.
- Make some of the old keywords synonyms - I'd just propose where I see fit, and the community will vote on it. Or we could discuss that here systematically.
Others will remain as general-purpose tags.
I would like to know how the community feels about this before I proceed.