CREATE OR REPLACE VIEW "quilt_packages_{bucket}_view" AS
regexp_extract("$path", '^s3:\/\/([^\\/]+)\/([^\/]+)\/([^\/]+)\/([^\/]+)', 4) as user,
regexp_extract("$path", '^s3:\/\/([^\\/]+)\/([^\/]+)\/([^\/]+)\/([^\/]+)\/([^\/]+)', 5) as name,
regexp_extract("$path", '[^/]+#x27;) as timestamp,
"quilt_named_packages_{bucket}"."hash"
FROM "quilt_named_packages_{bucket}"
regexp_extract("$path", '[^/]+#x27;) as tophash,
"quilt_manifests_{bucket}" as manifest
WHERE manifest."logical_key" IS NULL
npv."hash" = mv."tophash"