Niko Neugebauer touches on something I want for on-premises SQL Server:
In Azure Synapse Analytics (Azure SQL DW) we have a tool that can help us – the query labels. Firing up the same analytical query, but this time with the OPTION (LABEL = ‘QueryLabelIdentification’) can help us with the identification of the processing. So for the test example I have simply included the format QL – [Query Pupose] where QL stands for Query Labelling:
I think this would have a lot of value on-prem, especially if you are using Query Store.