nix-path-info.sh

#!/usr/bin/env nix-shell
#!nix-shell -i bash -p sqlite -p bash

SQL=$(cat <<EOF
select * from DerivationOutputs do    
  inner join ValidPaths vp on vp.id = do.drv
  inner join Refs r1 on r1.referrer = vp.id                          
  inner join ValidPaths vp2 on r1.reference = vp2.id
  where do.path GLOB '/nix/store/$1-*'
EOF
)
sqlite3 -readonly /nix/var/nix/db/db.sqlite "$SQL"