Sql::abstract::more generates sql from perl datastructures. this is a subclass of sql::abstract, fully compatible with the parent class, but with some additions:

1) additional sql constructs like -union, -group_by, join, etc;

2) methods take arguments as named parameters instead of positional parameters, so that various sql fragments are more easily identified;

3) values passed to select, insert or update can directly incorporate information about datatypes, in the form of arrayrefs of shape [$value, \%type].