正则表达式匹配SQL脚本SSMS中的最后一个方括号

我试图在SQL Server Management Studio 2017中执行正则表达式匹配,然后对如下所示的SQL脚本的一部分进行替换:

,ISNULL([Gt 01 To 02 Weeks SUM 1],0) AS [Gt 01 To 02 Weeks SUM]
,ISNULL([Gt 02 To 03 Weeks SUM 1],0) AS [Gt 02 To 03 Weeks SUM]

I want to match on the last [ and ] e.g. using example line [Gt 02 To 03 Weeks SUM]; so I can the replace [|] with '

我试过了

(?<=\sAS\s).*(\[)Gt|SUM(\])

这给出了:

enter image description here

这是全场比赛,而不是我希望替换的小组比赛

然后,我尝试:

(?<=\sAS\s).*?(\[)|(?<=\sAS\s)?(\])

But this matches one too many (i.e. it matches on the penultimate ] as well.

enter image description here

我尝试了其他一些尝试都无济于事。

Behaviour seems to match as per using PCRE PHP on regex 101. Example: here so I added that tag but I am not experienced enough in this domain to know if that is valid.

我如何更改此正则表达式,使其仅在最后一个括号中匹配?