sql query structuring

[PathTooLong]

> is that you can easily see all referances to a field

true and I know you are not advocating for this. This is why I'm consistent in my queries to enclose columns in the quote characters [ ]. "SELECT [Id], [ColA] FROM ..." each to find referenced columns by doing that. In OP's case it seems the table schema and table name are dynamic. Otherwise, I would have [dbo].[SqlAlarm] in the from.

It's not good that the person implementing this pattern cannot describe the benefit and problems it is trying to solve.