Search before asking

• I searched the issues and found no similar issues.

What Happened

TSQL / MS SQL has some poprietary functions that can be used for UPDATE TRIGGERs:

• UPDATE([column_name])
• COLUMNS_UPDATED()
  These are not recognized by SQLFluff

Expected Behaviour

This should be parseable:

CREATE TRIGGER reminder  
ON Person.Address  
AFTER UPDATE   
AS   
IF ( UPDATE (StateProvinceID) OR UPDATE (PostalCode) )  
BEGIN  
RAISERROR (50009, 16, 10)  
END;  
GO 

https://learn.microsoft.com/en-us/sql/t-sql/functions/update-trigger-functions-transact-sql?view=azuresqldb-current#examples

Observed Behaviour

Line 6, Position 6: Found unparsable section: 'UPDATE (StateProvinceID) OR UPDATE (Post...'

How to reproduce

run SQLFluff Online on statement from "Expected Behavior"

Dialect

tsql

Version

SQLFluff online: 3.0.7

Configuration

SQLFluff online: 3.0.7

Are you willing to work on and submit a PR to address the issue?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct