This software creates Data Manipulation Language (DML) commands automatically to manipulate relational databases. With this tool, users can quickly generate complex SQL queries and modify database contents efficiently.
Apart from the Builder patterns, the software also features a Facade patterned Database object that wraps a Datasource object. This provides a framework for executing the results produced by the Builder objects while simplifying transaction and batch management. The Database object is also capable of handling SQL exceptions transparently in a default manner. Additionally, it provides a simple object-oriented approach via wrappers around the database metadata.
SQL Construction Kit is designed to make the creation of runtime dynamic SQL easy without DDL (Data Definition Language) builders. While the DDL for various databases is highly varied, trying to abstract it to a single generation framework would be counterproductive. There are no plans to address DDL in the future, making SQL Construction Kit solely dedicated to this objective.
Developers using SQL Construction Kit will find it to be an active project as the developer works on the code, javadoc, or wiki documentation on a daily basis. Therefore, developers can check back often for improvements and updates to the software.
Version 2009-01-23: N/A