Formatter Option for Inserting Newline for A Single JOIN?

Toad for SQL Server
1

Hi,

Other than specifying a margin (which I prefer to leave at 999), is there a Formatter option that fully newlines a query with a single JOIN? This is what I mean:

7041.Capture.jpeg
7041.Capture.jpeg852×348 26.7 KB

I'd be OK with the "ON" indented as well, but I'm mostly interested in putting a newline before the INNER JOIN, like Formatter usually does with multiple JOINs.

Alternatively, this could be a bug in the parser where the Formatter newline/indents multiple JOINs but not a single JOIN. It is independent of the setting for Alignments -> DML statements -> Try to put very simple queries on a single line.

Best,

KJ

2

I’m keen to get an answer for this too. Is there a solution to this yet?

3

I’ll try to work on this in the next couple of weeks.

Thanks,

Andre

4

I added an DML option called “Always put a join on a new line” which will avoid JOIN and ON keywords to appear on the same line. (default value is unchecked)

Actually this was not a bug, it was rather by design, but everything is a matter of taste. Your suggestion made sense to me.

It will appear in on of the next Toads.

Thanks,

Andre