{"package":"pypika","ecosystem":"conda","latest_version":"0.51.0","description":"A SQL query builder API for Python","license":"Apache-2.0","license_risk":"permissive","commercial_use_notes":"Permissive: commercial closed-source use OK; preserve the copyright notice.","homepage":"https://github.com/kayak/pypika","repository":"","downloads_weekly":430,"health":{"score":59,"risk":"high","breakdown":{"maintenance":20,"popularity":3,"security":25,"maturity":9,"community":2},"deprecated":false,"max_score":100},"vulnerabilities":{"count":0,"critical":0,"high":0,"medium":0,"low":0,"details":[]},"versions":{"latest":"0.51.0","total_count":4,"recent":["0.48.8","0.48.9","0.50.0","0.51.0"]},"metadata":{"deprecated":false,"deprecated_message":null,"maintainers_count":1,"first_published":"2021-10-25 08:47:15.899000+00:00","last_published":"2026-02-02 19:08:16.299000+00:00","dependencies_count":0,"dependencies":[]},"github_stats":null,"bundle":null,"typescript":null,"known_issues":{"bugs_count":0,"bugs_severity":{},"status_breakdown":{},"link":null,"scope":"none"},"historical_compromise":null,"recommendation":{"action":"safe_to_use","issues":[],"use_version":"0.51.0","version_hint":null,"summary":"pypika@0.51.0 is safe to use (health: 59/100)"},"version_scoped":null,"requested_version":null,"_cache":"miss","_response_ms":257,"_powered_by":"depscope.dev — free package intelligence for AI agents","typosquat":{"is_suspected":false},"maintainer_trust":{"available":false},"malicious":{"is_malicious":false},"scorecard":{"available":false},"quality":{"available":false},"version_history_summary":{"total_versions":4,"first_release_age_days":1649,"last_release_days_ago":87,"avg_days_between_releases":550,"release_velocity":"active"},"popularity_warning":{"this_ecosystem_downloads":430,"more_popular_in":{"ecosystem":"pypi","downloads_weekly":2899467},"hint":"This is the conda package 'pypika' (430 dl/week). A much more popular package with the same name exists in pypi (2,899,467 dl/week). Confirm you queried the right ecosystem."}}