Please look at parenthesis formatting for WHERE EXISTS

Nikos226

Hello,

I asked this question a few months ago and received no response, so I'm attempting to bring attention to this issue again.

I often use WHERE EXISTS in my SQL, but I'm unable to control how parenthesis format with my preferred parenthesis style Expanded, to statement. I also set Operators Alignment to first list item and Place AND / OR keyword before the condition is checked.

Formatting is tolerable when using two other parenthesis styles Expanded, Simple or Compact, Simple (see samples below), but what I'd really like is to be able to have it with my preferred style.

Is there a way this functionality can be reviewed - or is this something I just need to deal with? I included my format style as well. Thank you.

Here are some samples:

Expanded, Simple
Indent parenthesis contents = checked


Compact, Simple
Indent parenthesis contents = not checked


Expanded, to statement (preferred style - but has parenthesis formatting issue)
Indent parenthesis contents = checked


WISHLIST TO CORRECT
Expanded, to statement (preferred style - no parenthesis formatting issue)
Indent parenthesis contents = checked

Nikos226

I need to point out that a FREE addon (Poor Mans T-SQL Formatter) can do this type of formatting without issue at all.

Thank you.

Alex B

Hi @Nikos226,

What version of SQL Prompt are you using?  I have an option for "Expanded, indented" which formats my sample query exactly as you are looking for:
​

You didn't mention this in your other examples, but it looks just like your last "wishlist" example.

If you do have this option, is there a reason you do not want to use it?

Kind regards,
Alex

Nikos226

My example is clearly showing broken formatting with EXISTS. Instead of having parenthesis directly under the operator EXISTS, they for formatted to similar to JOIN.

Sample with this without exists

AND
(
     1=1
)

You'll notice parenthesis are aligned directly under the AND operator.

However parenthesis are not aligning directly under the EXISTS operator.

Yes - your example shows something similar, but this doesn't address the root issue and all parenthesis styles will use this formatting, which is something I'm looking to avoid.

 

Jessica R

Hi @Nikos226 ,

Thank you for clarifying that! I'm afraid though that aligning the EXISTS directly under the parentheses isn't possible at the moment. Can you please add a feature request for this option to our uservoice forum: https://redgate.uservoice.com/forums/94413-sql-prompt

Thank you and so sorry for the lacking option!