Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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

by 1nickt (Canon)
on Jun 04, 2021 at 20:48 UTC ( [id://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?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (3)
As of 2024-04-19 20:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found