-rmdep='delete from packagedeps where %s and requires = %s;\n'
-cleardeps='delete from packagedeps where %s;\n'
+rmdep='delete from packagedeps P where %s and requires = %s;\n'
+cleardeps='delete from packagedeps P where %s;\n'
+libdeps="select distinct EN.needed from elfneeded EN join packagefiles P on P.hash = EN.file where %s;\n"
+resolvelibs="select distinct EN.needed from elfneeded EN join packagefiles PF on PF.hash = EN.file left join where %s;\n"