Can "Swap order of columns in join clauses" be enabled automatically if upgrading from an earlier version e.g. 5
WIth the change in v6 to default to
SELECT * FROM table1
INNER JOIN table2
ON table2.id = table1.id
whereas previous versions used this format.
SELECT * FROM table1
INNER JOIN table2
ON table1.id = table2.id
If upgrading from an earlier version, can either the swap order option be enabled or at least the user warned during installation that the intellisense options have changed and that queries will be formatted differently.
1
vote
Kieron O'Connor
shared this idea
Thanks for your suggestion Kieron.
In adding this new option, we set the default column order to what we think will be the most useful. If you prefer the old behaviour, select the new option – your option preferences will be persisted when you install new versions of SQL Prompt.