DTP SQL Development Tools Project

Project Overview

The SQL Development Tools project provides frameworks and tools for deep and broad SQL support.

What's New

• November 28, 2008: Development schedule posted
• June 2008: SQL Query Builder added to available tools

Project Components

• Routines Editor Framework
  
  An extensible framework for editing database routines and SQL statements. Vendor-specific extensions enable specialized support for particular databases.

• SQL Query Parser
  
  Although SQL is defined by a standard, several major dialects exist. Thus, while the standard must be supported, practicality also demands flexibility in adjustment to dialects. The SQL Query Parser meets these needs by providing an extensible framework, enabling dialect-aware SQL components and tools.

  IMPORTANT: Obtaining lpg.jar required by the SQL Query Parser

  Using the SQL Query Parser (HTML)

The tools include:

• SQL Editor
  
  The SQL Editor will provide an exemplary tool for standard text-based editing of SQL statements. Providing content assist tied to the SQL Model, syntax colorization, and multiple statement support, this editor will provide an essential tool for data-centric development.

• Visual SQL Builder
  
  The Visual SQL Builder allows for graphical editing of SQL, raising the level of abstraction, increasing developer productivity, and making query construction possible for a wider user base.

• Results View
  
  The Results View displays the output of routine or SQL statement execution in a tabular form typical of SQL result sets. These results can be exported to persistent storage in a variety of formats and reloaded at a later time into the results view.

• Script History
  
  Typically a number of scripts will be executed repeatedly during the course data-centric development. The ability to retain a history of these queries and thereby quickly repeat execution of them and view results increases productivity. The Script History is a view meeting these needs, based on a development session.