Properly format the start of a CTAS in Azure Synapse Analytics
SQL Prompt does not start a new line for the SELECT portion of a CTAS statement within Azure Synapse Analytics when there is a defined distribution or index using a WITH clause. Instead the SELECT statement is tabbed way over to the right.
David Smith commented
Yes, please! I've been frustrated with this since returning to redgate. Seems like a simple implementation, almost more of a bug than a feature request.