Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Option for Line break between tables in join

Multiple tables in the join statement are indented correctly, but no option to add a line break between the table joins. I find this line break to help legibility when dealing with many tables in a join.

I think adding the option "break before JOIN keyword" would solve that issue, and not require evaluating for subquery or further complex on statement conditions.

0 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Sheldon shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already implemented.

    The settings are in the formatting profile, jut search for "Line Break BEFORE/AFTER JOIN" keyword.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  • Sheldon commented  ·   ·  Report

    Right now all line breaks are "honored" if they are there, but it doesn't put the line break in between the joined conditions. I'm asking for the option to force a line break between the table joins to add a single blank line between, for legibility.

    select
    *
    from
    table1
    innerjoin table2 on test = test

    TO

    select
    *
    from
    test1

    inner join test2 on test1=test2

    inner join (subquery) t3 on test1 = test3