Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

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

by 1nickt (Abbot)
on Jun 04, 2021 at 20:48 UTC ( #11133531=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11133531]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (3)
As of 2021-10-18 17:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (74 votes). Check out past polls.

    Notices?