Integrating SuperSQL in Software Development Environment Systems

SuperSQL is an extension of SQL that allows various application data to be directly generated from a query. The query syntax is similar to SQL with additional data formatting capabilities. A SuperSQL query can generate different kinds of output such as a HTML files, LaTeX files, Flash animations, MS-Excel worksheets, PDF, etc. While SuperSQL may be very useful for media publishing and presentations, its use could be complicated. Complex queries may result from the inclusion of formatting data and when errors occur in such queries, debugging could be difficult. To address these problems, we designed a tool that allows syntax highlighting, execution, HTML output viewing and error reporting of SuperSQL queries and integrated it to the Eclipse development environment. We then conducted a study to evaluate its usefulness.