DBI::Easy::SQL - handling sql for DBI::Easy
This module is a SQL expressions constructor for DBI::Easy. So DBI::Easy::SQL is a wrapper between SQL and the rest part of DBI::Easy
returns a list of SQL columns
creates a SQL DELETE query
creates a SQL INSERT query
adds limits to SQL query
add ORDER BY to SQL query
create placeholders for ranged sql statements, as example by
... where column in (?, ?) ... insert into table (col1, col2) values (?, ?) ...
receive number of placeholders to generate or arrayref, returns
join ', ', ('?' x $num)
creates SELECT SQL query
creates SET SQL expression (for UPDATE query as an example)
creates UPDATE SQL query
creates WHERE SQL expression
<apla at the-singlers.us>
Please report any bugs or feature requests to my email address, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Class-Easy. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.
Copyright 2008-2009 Ivan Baktsheev
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.