text: create materialized view dependents (
    name,
    namespace,
    dependent_id) as
      select distinct p3.name as name, p3.namespace as namespace, p0.package_id as dependent_id
      from "packages" as p0
      inner join "releases" as r1 on r1."package_id" = p0."package_id"
      inner join "requirements" as r2 on r2."release_id" = r1."release_id"
      inner join "packages" as p3 on p3."package_id" = r2."package_id";
  
  create index on dependents (name, dependent_id);
  create unique index on dependents (name, namespace, dependent_id);
  