https://metacpan.org/release/MSTROUT/SQL-Abstract-1.90_03
is the latest, and DBIx::Class cpan installs against it, so I've hopefully not cocked up compatibility *too* badly though I'm sure we're going to need to add a bunch of extra test cases as you guys start beating on it. (Mojo::Pg needed its tests switching to SQL::Abstract::Test and that's in master but not yet released) This release seperates the SQL generation into two phases, a DWIM expression -> explicit abstract query tree phase, and then a phase that takes an AQT and converts it to SQL+bind parameters. Best elucidation of this currently is SQL::Abstract::Reference and this dev release also provides a proof of concept SQLMaker role that does its best to expose all of the new features in spite of the horrible things that I did in SQLMaker years ago. Short notes on how that works out here: https://metacpan.org/pod/release/MSTROUT/SQL-Abstract-1.90_03/lib/DBIx/Class/SQLMaker/Role/SQLA2Passthrough.pm Additionally, the ExtraClauses and BangOverrides plugin between them expose clauses that DBIx::Class doesn't know about and allows wrapping existing ones - for examples of adding extra custom joins, and of using the new SQLA2 CTE support, see: https://metacpan.org/pod/release/MSTROUT/SQL-Abstract-1.90_03/lib/SQL/Abstract/Plugin/BangOverrides.pm Additionally, there's now a much more elegant and powerful extension system as documented in SQL::Abstract itself (though you'll want to read ::Reference as well to understand exactly how and why you might want to use it). Bend it, break it, provide feedback, please. -- Matt S Trout - Shadowcat Systems - Perl consulting with a commit bit and a clue http://shadowcat.co.uk/blog/matt-s-trout/ http://twitter.com/shadowcat_mst/ Email me now on mst (at) shadowcat.co.uk and let's chat about how our CPAN commercial support, training and consultancy packages could help your team. _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk