Hi, I just became aware of the Scout project. I noticed on the Scout wiki that Scout makes use of the Connectivity component of the DTP (Data Tools Platform) project. I was wondering, does Scout make use of DTP in other ways? (I'm the DTP PMC Lead, by the way.)
Also, I saw an announcement that Scout is doing SQL formatting. How are you implementing that?
Yes we make use of DTP in the scout sdk environment together with pde and jdt.
With regard to sql formatting and parsing: we have such components for almost 10 years now and feel happy to contribute that together with scout.
The sql parser is a rule based parser thus can parse most of the sql styles and standards including inner selects, insert select, with etc.
It consists of the 3 parts "into parsing", "bind parsing" and "rule syntax parsing"
The formatter operates on a parsed model and formats based on the "block output" concept.