format Window functions
SQL Prompt fails badly in formatting window functions. As these are present at least since SQL 2014, SQL Prompt should be able to interpret them and format them accordingly.
I would format the LAG() function as follows:
myColumn AS realColumn
,LAG(myColumn, 1, 0)
PARTITION BY someColumn
ORDER BY anotherColumn) AS calculatedColumn
Try this with SQL Prompt - it's result is not very nice...
Günter Tschech shared this idea
Günter Tschech commented
...and the input window killed all my formatting :-/