{ "_id": "6ad5ed0e4a34890ab4939308", "Package": "SQLove", "Title": "Execute 'SQL' Scripts in 'R' Containing Multiple Queries", "Version": "1.0.2", "Authors@R": "person(\"Kerns\", \"Sam\", , \"samwkerns@gmail.com\", role = c(\"aut\", \"cre\"))", "Description": "The nature of working with structured query language\n('SQL') scripts efficiently often requires the creation of\ntemporary tables and there are few clean and simple 'R' 'SQL'\nexecution approaches that allow you to complete this kind of\nwork with the 'R' environment. This package seeks to give 'SQL'\nimplementations in 'R' a little love by deploying functions\nthat allow you to deploy complex 'SQL' scripts within a typical\n'R' workflow.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "7.2.3", "VignetteBuilder": "knitr", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-19 10:09:54 UTC", "User": "root" }, "Author": "Kerns Sam [aut, cre]", "Maintainer": "Kerns Sam ", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2025-04-17 06:40:01 UTC", "RemoteUrl": "https://github.com/cran/SQLove", "RemoteRef": "HEAD", "RemoteSha": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "_user": "cran", "_type": "src", "_file": "SQLove_1.0.2.tar.gz", "_fileid": "https://r2.ropensci.org/7a7ff9c18b4939a921de1601319988ec835aad0bb0d6f39bd4fcb9d1fbe1f4e0", "_filesize": 88927, "_sha256": "7a7ff9c18b4939a921de1601319988ec835aad0bb0d6f39bd4fcb9d1fbe1f4e0", "_expires": "2027-01-27T10:12:28.000Z", "_created": "2026-10-19T10:09:54.000Z", "_published": "2026-10-19T10:12:29.926Z", "_buildurl": "https://github.com/r-universe/cran/actions/runs/39234929160", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 118003420196, "time": 111, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "12178861891" }, { "job": 118003420291, "time": 107, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "12179435870" }, { "job": 118002277962, "time": 166, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12178601596" }, { "job": 118003420149, "time": 125, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12178702024" }, { "job": 118003420172, "time": 67, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "12179565605" }, { "job": 118003420208, "time": 65, "config": "windows-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "12179395744" } ], "_upstream": "https://github.com/cran/SQLove", "_commit": { "id": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "author": "Kerns Sam ", "committer": "cran-robot ", "message": "version 1.0.2\n", "time": 1744872001 }, "_maintainer": { "name": "Kerns Sam", "email": "samwkerns@gmail.com", "login": "samkerns", "description": "Lead Data Scientist | Researcher | Data Storyteller", "uuid": 62064156 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "DBI", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "RJDBC", "role": "Imports" }, { "package": "odbc", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "samkerns", "count": 6, "uuid": 62064156 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 634, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 353, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SQLove" }, "_searchresults": 3, "_topics": [ "openjdk" ], "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/SQLove.html", "LICENSE" ], "_homeurl": "https://github.com/samkerns/sqlove", "_realowner": "samkerns", "_cranurl": false, "_releases": [ { "version": "0.0.1", "date": "2023-02-16" }, { "version": "0.0.2", "date": "2023-03-06" }, { "version": "0.0.3", "date": "2023-11-10" }, { "version": "0.0.4", "date": "2023-11-13" }, { "version": "1.0.1", "date": "2025-04-10" }, { "version": "1.0.2", "date": "2025-04-17" } ], "_exports": [ "dbGetMultiQuery", "dbSendMultiUpdate" ], "_help": [ { "page": "dbGetMultiQuery", "title": "Query a database with multiple query actions and one, final, select statement.", "topics": [ "dbGetMultiQuery" ] }, { "page": "dbSendMultiUpdate", "title": "Run multiple SQL query actions within the DB environment.", "topics": [ "dbSendMultiUpdate" ] } ], "_readme": "https://github.com/cran/SQLove/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cli", "clipr", "cpp11", "crayon", "DBI", "glue", "hms", "lifecycle", "magrittr", "odbc", "pillar", "pkgconfig", "prettyunits", "progress", "R6", "Rcpp", "readr", "rJava", "RJDBC", "rlang", "tibble", "tidyselect", "tzdb", "utf8", "vctrs", "vroom", "withr" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-25-jre-headless", "headers": "openjdk-25-jre-headless", "source": "openjdk", "version": "25.0.4.1+1-1~26.04.4", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_vignettes": [ { "source": "SQLove.Rmd", "filename": "SQLove.html", "title": "SQLove - Simple Functions for Complex Queries", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "The Problem", "dbGetMultiQuery", "dbSendMultiUpdate" ], "created": "2023-02-16 14:30:11", "modified": "2025-04-17 06:40:01", "commits": 2 } ], "_score": 2.6989700043360187, "_indexed": false, "_nocasepkg": "sqlove", "_universes": [ "cran" ], "_indexurl": "https://samkerns.r-universe.dev/SQLove", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.2", "date": "2026-10-19T10:11:49.000Z", "distro": "resolute", "commit": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "fileid": "https://r2.ropensci.org/8456183af06a5f591be8a0f312ef6dcbcb6139f2fe2e66f61dba02e59cc3eb16", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/cran/actions/runs/39234929160" }, { "r": "4.6.1", "os": "linux", "version": "1.0.2", "date": "2026-10-19T10:11:46.000Z", "distro": "resolute", "commit": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "fileid": "https://r2.ropensci.org/eb0244f8b2512d862ca22643045ff1fb1d02b3658a5ca4eb0a0926310fa5cdba", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/cran/actions/runs/39234929160" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.2", "date": "2026-10-19T10:12:12.000Z", "commit": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "fileid": "https://r2.ropensci.org/16d50dcdcf86703d009f5a5a02383519206bc8c57226ad97fbb7380c5b0df4a8", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/39234929160" }, { "r": "4.7.0", "os": "win", "version": "1.0.2", "date": "2026-10-19T10:11:02.000Z", "commit": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "fileid": "https://r2.ropensci.org/5247fd5b682442fbe2f3840c23704485129b5ba81c864e84cffefe0b9a676bb9", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/cran/actions/runs/39234929160" }, { "r": "4.6.1", "os": "win", "version": "1.0.2", "date": "2026-10-19T10:11:01.000Z", "commit": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "fileid": "https://r2.ropensci.org/26d26a5dc0dab882e272cf41fd53620ea71700e8329a721bad6df7fd1051b8d9", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/cran/actions/runs/39234929160" } ] }