Transformation editor in Designer should support comments and preserve user formatting

We should support the ability to put comments into transformation code. This is especially useful for virtual procedures, which can get complicated, and could benefit from comments. It also comes up when bringing in SQL code from another environment (e.g. a view from Oracle) – it would be nice to be able to preserve the comments from the original environment.

It would be nice to support comments prefixed by "--", such as in Oracle. I believe this is standard SQL-92, so we should support it as well.

-------------------

Fix the designer transformation window, so that it actually saves what the user types (keep formatting, allow comments, etc.). This should really be one of the standard Eclipse text editing windows - MM specific stuff (other than syntax highlighting) should be decoupled from the edit window - there are a couple of requests from ING on this.

-------------------

As Designer is treated like any other development environment and may have multiple developers working on the same project set, it is very important that comments be supported within the transformations. Although it might be helpful, it is not necessary that these comments get pushed out to source. These comments would be primarily used for developer references.