The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

Changes for version 0.13

  • In SQL::Maker
    • Allow 'INSERT IGNORE' by $opts->{prefix} params at insert() method (zigorou)
    • Accept key-value as array at insert() method (zigorou)
    • Accept value using subquery at insert(), update() method (zigorou)
    • Allow table alias at select() method (zigorou)
  • In SQL::Maker::Plugin::InsertMulti
    • Accept values as arrayref at insert_multi() (zigorou)
    • Allow 'INSERT IGNORE' by $opts->{prefix} params at insert_multi() (zigorou)
    • Allow literal and subquery in values at insert_multi() (zigorou)
    • Supports 'ON DUPLICATE KEY UPDATE' syntax on mysql driver at insert_multi() (zigorou)
  • In SQL::Maker::Select
    • Allow no conditional join (zigorou)

Documentation

Modules

Yet another SQL builder
condition object for SQL::Maker
insert multiple rows at once on MySQL
SQL Types wrapper
dynamic SQL generator
provides set functions

Provides

in lib/SQL/Maker/Select/Oracle.pm
in lib/SQL/Maker/Util.pm