I was playing with the Data Explorer, and was doing a simple query to see how many posts appeared by month. This was my query:
select datepart(year, p.creationdate) as year, datepart(month, p.creationdate) as month, count(*) as postcount from posts p group by datepart(year, p.creationdate), datepart(month, p.creationdate) order by datepart(year, p.creationdate), datepart(month, p.creationdate)
However, "datepart" and "month" aren't being recognised as keywords for syntax highlighting. This is understandable for the main site, since it's a bit obscure, but it might be helpful to increase the number of recognised reserved words for the SEDE editor, since it only needs to handle the one language.
Having noticed this, I did a bit of extra playing. The editor appears to not know the TSQL CASE statement, either:
case when [body] like '%sql%' then 1 else 0 end highlights only the "like '%sql%'" and the 1 and 0.
Is it possible to add these in?