T-SQL rule: Make alias style consistent

[fdw]

I'm not even sure if rules just for one dialect are possible, but if so, the following would be nice:

T-SQL allows an additional style of aliasing, namely

select
  alias1 = column1

Currently, it's possible to use both even in the same query. It would be nice if sqlfluff could make this consistent (always as, always =, consistent within the query).

[tunetheweb]

To me this could be an extension of L011 or L012. Especially if it forces as - then it would just be a matter of recognising and replacing the = for t-sql.

An extras step would be to offer the option of preferring (=), though as that's T-SQL specific it might be more confusing for others reading the docs.

[fdw]

Yes, sounds like L012.

However, I have to say I quite like the = syntax, so I would maybe want to enforce it with sqlfluff. But, as you say, that would make at least the docs more confusing (and likely the code as well).

[infused-kim]

Yes, sounds like L012.

However, I have to say I quite like the = syntax, so I would maybe want to enforce it with sqlfluff. But, as you say, that would make at least the docs more confusing (and likely the code as well).

Hell yeah... team-= uprising. I finally found another person who prefers the = syntax...

So I am adding another vote for the ability to enforce the = syntax.