Benefits Of Using SQL Ordinal Position Notation?

I’d use it:

• If you love troubleshooting
• Creating adhoc queries without intellisense

There is no upside.

SQL Server only supports in the ORDER BY anyway. Anywhere else it’s an expression to be evaluated.