Can I express xpath like queries, like find all elements which are descendants of another element but the direct parent is matching a special criterion?

How would that look like in SQL?

Edit

I'm aware that xpath is for XML and not JSON. Just ignore the missing axes...

Cheers Rolf
(addicted to the Perl Programming Language :)
Wikisyntax for the Monastery


In reply to Re^3: [OT] Re^3: Examples or tutorials for Perl grammars? by LanX
in thread Examples or tutorials for Perl grammars? by LittleJack

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":