Subquery indentation aligned with paranthesis
Requesting a tweak to the indentation level settings for subqueries.
If I have it set to have closing parenthesis on a new line, I'd like the option to align the whole thing with the starting parenthesis, and this to be the alignment point of the subquery. Increases legibility when lots of subqueries are involved.
Targeted format:
select
1
,2
,3
from
table11 t
inner join table2 t2
on t.value = t2.value
inner join ( -- starting parenthesis
select
1
,2
,3
from
subquerytable3
where
test = test
) f on t.value = v.value
and t.value2 = v.value2
where
test = test
CURRENT FORMAT ALIGNS TO THE KEYWORD ONLY, not parenthesis.
select
1
,2
,3
from
table11 t
inner join table2 t2
on t.value = t2.value
inner join ( -- starting parenthesis
select
1
,2
,3
from
subquerytable3
where
test = test
) f on t.value = v.value
and t.value2 = v.value2
where
test = test
-
AdminDevart
(_, Devart)
commented
Hi,
Thanks for your patience!
Just want to inform you that it is already implemented.
The settings are in the formatting profile.
So we would like to suggest updating to the latest version and check there.
Best,
Devart Support Team
-
Sheldon commented
I'd also like to recommend this forum have some "code block" option so when we are posting ideas back you actually get the code block in the right format.
preformatted code block
<pre>
select
1
,2
,3
from
table11 tinner join table2 t2
on t.value = t2.valueinner join ( -- starting parenthesis
select
1
,2
,3
from
subquerytable3
where
test = test
) f on t.value = v.value
and t.value2 = v.value2
where
test = test
</pre>