{"package":"r-sqldf","ecosystem":"conda","latest_version":"0.4_10","description":"The sqldf() function is typically passed a single argument which  is an SQL select statement where the table names are ordinary R data  frame names.  sqldf() transparently sets up a database, imports the  data frames into that database, performs the SQL select or other statement and returns the result using a heuristic to determine which  class to assign to each column of the returned data frame.  The sqldf()  or read.csv.sql() functions can also be used to read filtered files  into R even if the original files are larger than R itself can handle. 'RSQLite', 'RH2', 'RMySQL' and 'RPostgreSQL' backends are supported.","license":"GPL-2.0-only","license_risk":"unknown","commercial_use_notes":"verify manually — license not parseable / not declared.","homepage":"https://github.com/ggrothendieck/sqldf, https://groups.google.com/group/sqldf","repository":"","downloads_weekly":457,"health":{"score":54,"risk":"high","breakdown":{"maintenance":15,"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.4_10","total_count":3,"recent":["0.4_10","0.4_11","0.4_12"]},"metadata":{"deprecated":false,"deprecated_message":null,"maintainers_count":1,"first_published":"2021-05-25 19:10:02.723000+00:00","last_published":"2026-01-30 08:42:02.929000+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":"use_with_caution","issues":["Moderate health score (54/100) — verify manually"],"use_version":"0.4_10","version_hint":null,"summary":"r-sqldf@0.4_10 low health (54/100) — consider alternatives"},"version_scoped":null,"requested_version":null,"_cache":"miss","_response_ms":765,"_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":3,"first_release_age_days":1802,"last_release_days_ago":92,"avg_days_between_releases":901,"release_velocity":"moderate"}}