2005-05-13 Darren Duncan <[EMAIL PROTECTED]> --------------------------------------------------
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
