Find which EXPath packages declare a particular dependency, in eXist-db

list-packages-with-dependency.xq

xquery version "3.1";

declare namespace pkg="http://expath.org/ns/pkg";

array {
    for $app in xmldb:get-child-collections("/db/apps")
    let $package-metadata := doc("/db/apps/" || $app || "/expath-pkg.xml")
    where $package-metadata//pkg:dependency[@package eq "http://exist-db.org/apps/shared"]
    order by $app
    return
        $app
}