Schema intersection and new parser functionality.

[NTDLS]

Merged the final part of the two major rewrites. I do not expect any further large breaking changes.

Lots of fixes, speed improvements, UI issues resolved, static analyzer fixes and updates.
The vast majority of the changes are to StaticSchemaIntersectionProcessor, which was literally rewritten from the ground up. This may introduce bugs, but it MMUCH more readable, understandable, optimizable, performant and maintainable.

oh, and Scaler -> Scalar 😲

Added support for updating with join:

Can now SORT and GROUP queries by complex expressions and aggregations functions.

So finally you can query and order by count(*) desc

Can now connect to more than one server:

Code collapse improvements:

Schema awareness:

[NTDLS]

@ingted Check out the notes on 0.22.0 and 0.23.0.

Also, check out Regression.kbs. This is a major milestone! The script has no parser issues and executes successfully. If you run it in the UI, it probably wont show the results grids due to to many result-sets. Regardless, it works!!

I also think I got all the tests you made working with the new project structure.

[ingted]

Cool!! I will read the code of StaticSchemaIntersectionProcessor carefully!!