[Dbix-class] Time to start testing SQL::Abstract dev releases, please
Matt S Trout
mst at shadowcat.co.uk
Sun Oct 13 19:08:45 GMT 2019
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:
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
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
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.
More information about the DBIx-Class