Wishlist: Better handling of complex expressions in beautifier

[Jaume]

Hello.
I'd like a better handling of the complex conditional expressions with lots of parenthesis in PL/Beautifier. It'll be nice the ability to align the inner parenthesis, something like:

select empno, deptno
from emp
where (empno != 1 and empno != 3)
or (empno != 3
and ((empno != 5
and empno != 7)
or empno = 10
))

 

[Jaume]

Well, the formatting has removed the spaces

Just wanted to align the several nested conditional expressions.

 

[Marco van der Linden]

Something like this perhaps?

select empno, deptno
from   emp
where  (empno != 1 and empno != 3
       )
       or (empno != 3
           and ((empno != 5
                 and
                 empno != 7
                )
                or empno = 10
               )
          )

 

[Jaume]

Exactly like this!!!!!