Allow item following AND/OR to be on new line
When formatting SQL, it would be good to have the option to put the item following an AND/OR on a new line and align it, so instead of:
WHERE
OutgoingResults.LoadDateKey = 20191106
AND OutgoingResults.FeedName = 'TestFeed'
we have
WHERE
OutgoingResults.LoadDateKey = 20191106
AND
OutgoingResults.FeedName = 'TestFeed'
-
Louis Somers commented
Also other options, For example, I prefer `ON` clauses to be aligned with the additional (AND / OR) conditions right aligned with `ON`.
(Removed example since UserVoice removes all whitespace)
-
Steven Oates commented
Fantastic idea Gavin, I've been waiting for this for years. We also conform to a new line after each operator also with an indent however this formatting option isn't available in prompt.
-
Anonymous commented
Much cleaner to read