The pure perl, join-enabled SQL::Statement version 1.0 is now available at
http://www.cpan.org/authors/id/J/JZ/JZUCKER/SQL-Statement-1.0.tar.gz The module allows SQL (Structured Query Language) access to data in many formats including CSV, fixed-length, tab or pipe "delimited", Excel files, XML files, etc. If you use DBD::CSV, DBD::Excel, DBD::AnyData, or other modules that subclass SQL::Statement, you can gain access to a much expanded SQL repertoire just by installing this new SQL::Statement (see README for details). The module can also be used standalone or subclassed for a variety of SQL parsing and validating purposes. This is the first CPAN release of the pure perl version of the module. It was previously released in an XS version by Jochen Wiedmann who has turned over maintenance of it to me. The new Pure Perl version of SQL::Statement supports everything supported by the XS version and, additionally, at least partial support for the following features that are not supported at all by the XS version: * Explicit and implicit joins * Table name aliases * Set functions (COUNT,MIN,MAX,AVG,SUM) * String functions (TRIM,SUBSTRING,UPPER,LOWER) * String concatenation * Numeric expressions * IN predicate * BETWEEN predicate * Alphabetic comparison in WHERE clauses * Ordering of text that looks like a number (e.g. 2001-01-17) * Verbose error messages for both Parsing and Execution errors Enjoy! -- Jeff
