SQL-Yapp - Yet Another Perl Preprocessor for SQL The SQL::Yapp module is an embedded preprocessor for Perl that lets you use native SQL expressions in Perl that can directly be used with e.g. DBI. Perl variables can be interpolated easily, and SQL substatements and expressions can be parsed separately and used in larger expressions. The goal is to make SQL injections impossible while using a natural SQL language syntax directly in Perl. This package also provides basic compile-time syntax checking of SQL. Example: my %values= ( title => 'The Language Construction Kit', author => 'Mark Rosenfelder', isbn13 => '978-0984470006', ); $dbh->prepare(sql{ INSERT INTO book SET %values }); The module has some capabilities to normalise SQL statements and translate between SQL dialects to ease porting. Currently, only INSERT ... SET statements are normalised to INSERT ... VALUES (but this is already quite handy for Perl, as shown in the example). Although the current SQL parser is far from complete, the basic stuff with many extensions already works. The man page gives an extensive overview of what is implemented. The major goals are security and ease of use, rather than completeness or efficiency. (Of course, it is tried not to mess up completely.) INSTALLATION To install this module, run the following commands: perl Makefile.PL make make test make install SUPPORT AND DOCUMENTATION After installing, you can find documentation for this module with the perldoc command. perldoc SQL::Yapp You can also look for information at: RT, CPAN's request tracker (report bugs here) http://rt.cpan.org/NoAuth/Bugs.html?Dist=SQL-Yapp AnnoCPAN, Annotated CPAN documentation http://annocpan.org/dist/SQL-Yapp CPAN Ratings http://cpanratings.perl.org/d/SQL-Yapp Search CPAN http://search.cpan.org/dist/SQL-Yapp/ LICENSE AND COPYRIGHT Copyright (C) 2011 Henrik Theiling This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License. See http://dev.perl.org/licenses/ for more information.