[VPM] ANNOUNCE: SQL-Routine-SQLBuilder 0.18 (and SQL-Routine 0.62)

[Darren Duncan]

2005-05-13   Darren Duncan <perl at DarrenDuncan.net>
--------------------------------------------------

Special Friday the 13th Release!

Version 0.62 of SQL::Routine (SRT), a fully atomic and portable 
abstract syntax tree to define any database tasks, has been uploaded 
to CPAN; it should appear on your favorite mirror within the next few 
hours.

http://search.cpan.org/dist/SQL-Routine/

So has version 0.18 of SQL::Routine::SQLBuilder, a reference 
implementation of a
SQL:2003 string builder (plus other SQL variants) for SQL::Routine.

http://search.cpan.org/dist/SQL-Routine-SQLBuilder/

So has version 1.04 of Locale::KeyedText, version 0.45 of Rosetta, 
and version 0.18 of Rosetta::Engine::Generic.

This release of SQL::Routine::SQLBuilder is particularly significant, 
and worth announcing, because it is the first release to actually be 
executed.  Prior versions were simply known to compile.  A bunch of 
small bug fixes and compatability updates were also made (details in 
'Changes'), but no large changes were necessary.

The new test suite for that module demonstrates the ability to 
generate SQL to create and drop database schema objects that are base 
tables (tables) and viewed tables (views) from SQL::Routine models, 
and in 3 SQL variants for each (uppercased and lowercased 
non-delimited identifiers, and case-preserving delimited 
identifiers).  For both object types, multiple data types are 
represented, as are foreign keys and aliased joins between a table 
and itself.

Various other updates were made that are detailed in the 'Changes' 
files.  Chief among them is that all the test suites were reorganized 
into multiple files that are better organized.

Subsequent releases will see improved input validation in 
SQL::Routine, and the demonstrated ability to generate other kinds of 
SQL in SQLBuilder.

Any questions, feedback, requests, or offers of assistence with the 
module are welcome and appreciated.

Thank you and have a good day. -- Darren Duncan