Feature request: extra format option for join tables

intGod

Currently, I can get SQL Prompt to format my SQL like this.

SELECT
    tbl.name AS TableName,
    col.name AS ColumnName
FROM
    sys.tables AS tbl
    INNER JOIN
        sys.columns AS col
    ON
        tbl.object_id = col.object_id

This annoys me because the tables in the FROM statement are not aligned. I would like to be able to achieve something like below where the tables are aligned and the join and ON are indented from the table. So the tables are indented from the FROM and the INNER JOIN is indented from the table. Then, the ON can either be indented from table or aligned to JOIN.

SELECT
    tbl.name AS TableName,
    col.name AS ColumnName
FROM
    sys.tables AS tbl
        INNER JOIN
    sys.columns AS col
        ON
            tbl.object_id = col.object_id
        AND @SecondJoinCondition = 1

DanC

Hi @intGod

Sorry, you're experiencing this formatting issue!

Would you be able to post the feature request on the UserVoice here please: https://redgate.uservoice.com/forums/94413-sql-prompt