WITH在tsql v标准版中

WITH in tsql v Standard

Is WITH used in more places than just for Common Table Expressions in either tsql or Standard SQL functionality?

Reason I ask is that I'd like to know what the reason is that a semi-colon is enforced in the statement before a CTEs WITH.

I'm assuming that the semi-colon is to help the parser, especially if WITH is used in more than one context, or if they are planning on using it in more than one context.