Beautifier Enhancements

[clivew]

I would just like to add my vote for control of where clauses.

Without a "one per line" option I really find the beautifier of little use.

I see that this option has been promised for some time in the forum. I do hope it is now imminent.

Also, this option should be independent of other options.

Thanks,
Clive

 

[Marco Kalter]

This will be added for 6.0.

 

[baloo]

Hi,
will be added join statement support?
Thanks,
baloo

 

[Marco Kalter]

Yes.

 

[Josh]

It would be wonderful if the beautifier could either:
- ignore where clauses altogether
- format the where clauses so that the boolean expressions were used as list delimiters, as in:
where a = b
and c = d
or j = d

 

[Josh]

Sorry, the leading spaces appear to have been dropped in my last post. The intent was to have the "and" and "or" keywords right-aligned with the "where" keyword. Thanks.

 

[Marco Kalter]

We'll have additional formatting options for where clauses in 6.0.

 

[dstrenz]

Originally posted by Marco Kalter:
We'll have additional formatting options for where clauses in 6.0.

Hi Marco,

Has there been a request for the following (pascal) style of formatting:

select
  a.a,
  a.b,
  b.a
from
  aaa a,
  bbb b
where
  a.a = b.a
order by
  a.a,
  a.b

If not, please add to your list.
Thanks.