select d.id dependency_id, p2."name" as package_name, v."version" as "version", v.id as version_id, p."name" as dependency_name
from packages p
join dependencies d on d.dependency_id = p.id -- upstream dependents
join versions v on v.id = d.version_id
join packages p2 on p2.id = v.package_id
where p.name = 'kubernetes'
Run this on CHAI sql, and I saw multiple dependency entries loaded, so something is wrong in the way I'm loading dependencies right now.
