DBIx::Class::SQLMaker - An SQL::Abstract-based SQL maker class
This module is a subclass of SQL::Abstract and includes a number of DBIC-specific workarounds, not yet suitable for inclusion into the SQL::Abstract core. It also provides all (and more than) the functionality of SQL::Abstract::Limit, see DBIx::Class::SQLMaker::LimitDialects for more info.
Currently the enhancements to SQL::Abstract are:
JOINstatements (via extended
HAVINGsupport (via extensions to the order_by parameter)
...FOR UPDATEtype of select statement modifiers
You may distribute this code under the same terms as Perl itself.