SQL-Interpolate-0.31

Changes for version 0.31 - 2005-09-27

SQL::Interpolate
Improved error reporting by sql_interp (recommended by mark stosberg)
Added support for ("WHERE", {x => \@v, ...}) ==> "WHERE (x IN (?,...) AND ...)". (recommended by multiple people)
Generate 'WHERE id = 5 and 1=1' and 'WHERE id = 5 or 1=0' rather than 'WHERE id = 5 and 1' and 'WHERE id = 5 or 0' for Oracle compatibility. (reported by wojciech pietron)
Fixed some improper handling of "use" parameters, e.g. $x in "use SQL::Interpolate FILTER=>$x"
Fixed various Exporter problems from custom import (reported by mark stosberg)
sql_interp.t and dbi.t - Fixed test case errors due to different hash order on MacOS. (reported by sean davis)
Documentation improvements.
SQL::Interpolate::Macro
Fixed: '^' and '$' are no longer automatically placed around regexes in 'relations' parameter. (reported by wojciech pietron)
DBIx::Interpolate
Added support for transparent caching of statement handles (no need to prepare()).
Fixed error in STX::fetchrow_hashref returning an arrayref rather than a hashref. (reported by mark tiefenbruck)
Added Carp

Integrates SQL::Interpolate into DBI

Simplified interpolation of Perl variables into SQL statements

Source filtering for SQL::Interpolate

Macros and SQL filters for SQL::Interpolate