http://qs321.pair.com?node_id=11133531


in reply to Is -nest part of SQL::Abstract? If so, is there documentation somewhere?

Hi,

"What does it do?"

Nothing you can't do with other syntax, as shown by this one-liner which reproduces the output documented for -nest in the old version choroba linked to here.

$ perl -Mstrict -MSQL::Abstract -wE 'say +(SQL::Abstract->new->select( +"foo", "bar", { user => "nwiger", -or => [ workhrs => { ">" => 20 }, +geo => "Asia" ]}))[0]'
SELECT bar FROM foo WHERE ( ( workhrs > ? OR geo = ? ) AND user = ? )

Hope this helps!


The way forward always starts with a minimal test.