sql-abstract

Ordering of columns in where clause when using SQL::Abstract

I have been reading some recipes in the Perl Hacks book. Recipe #24 "Query Databases Dynamically without SQL" looked interesting. The idea is to use SQL-Abstract to generate the SQL statement for you. The syntax to generate a select statement looks something like this: my($stmt, @bind) = $sql->select($table, \@fields, \%where, \@order...