{ "_id": "6a106fa8acfb0bcc41cab6f3", "Package": "sqlcaser", "Title": "'SQL' Case Statement Generator", "Version": "0.2.1", "Date": "2025-9-8", "Authors@R": "person(\"Leoson\", \"Hoay\", , \"leoson.public@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"https://orcid.org/0000-0003-2079-5579\"))", "Author": "Leoson Hoay [aut, cre] (ORCID:\n)", "Maintainer": "Leoson Hoay ", "Description": "Includes built-in methods for generating long 'SQL' CASE\nstatements, and other 'SQL' statements that may otherwise be\narduous to construct by hand.The generated statement can easily\nbe concatenated to string literals to form queries to\n'SQL'-like databases, such as when using the 'RODBC' package.\nThe current methods include casewhen() for building CASE\nstatements, inlist() for building IN statements, and\nupdatetable() for building UPDATE statements.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "7.3.3", "VignetteBuilder": "knitr", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-07 07:35:31 UTC", "User": "root" }, "Repository": "https://cran.r-universe.dev", "Date/Publication": "2025-09-09 07:20:02 UTC", "RemoteUrl": "https://github.com/cran/sqlcaser", "RemoteRef": "HEAD", "RemoteSha": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "MD5sum": "3fa462925504d51a31a4bde392e92234", "_user": "cran", "_type": "src", "_file": "sqlcaser_0.2.1.tar.gz", "_fileid": "fffb7b30e6dde1fbbc28d1a7993651a922bdc97e6f8cd1ac887ac27c450e9663", "_filesize": 104771, "_sha256": "fffb7b30e6dde1fbbc28d1a7993651a922bdc97e6f8cd1ac887ac27c450e9663", "_created": "2026-05-07T07:35:31.000Z", "_published": "2026-05-22T15:00:56.703Z", "_distro": "noble", "_jobs": [ { "job": 77405761117, "time": 114, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6849455998" }, { "job": 77405762061, "time": 148, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6849467756" }, { "job": 77405760420, "time": 134, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6849423150" }, { "job": 77405760144, "time": 91, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7163639556" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/25482423036", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/sqlcaser", "_commit": { "id": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "author": "Leoson Hoay ", "committer": "cran-robot ", "message": "version 0.2.1\n", "time": 1757402402 }, "_maintainer": { "name": "Leoson Hoay", "email": "leoson.public@gmail.com", "orcid": "0000-0003-2079-5579" }, "_registered": true, "_dependencies": [ { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [ { "week": "2025-37", "n": 1 } ], "_tags": [ { "name": "0.2.1", "date": "2025-09-09" } ], "_stars": 0, "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 495, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlcaser" }, "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/sqlcaser.html", "manual.pdf" ], "_realowner": "cran", "_cranurl": false, "_releases": [ { "version": "0.2.0", "date": "2023-11-24" }, { "version": "0.2.1", "date": "2025-09-09" } ], "_exports": [ "casewhen", "inlist", "updatetable" ], "_help": [ { "page": "casewhen", "title": "Generate a SQL CASE statement from a mapping file", "topics": [ "casewhen" ] }, { "page": "inlist", "title": "Generate a SQL IN statement from a mapping file", "topics": [ "inlist" ] }, { "page": "updatetable", "title": "Generate a SQL UPDATE statement from a mapping file", "topics": [ "updatetable" ] } ], "_readme": "https://github.com/cran/sqlcaser/raw/HEAD/README.md", "_rundeps": [], "_vignettes": [ { "source": "introduction.Rmd", "filename": "introduction.html", "title": "sqlcaseR: Building long CASE WHEN statements for SQL interfaces in R", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Demonstration", "Advanced Examples", "Using Named Columns and ELSE Clause", "Working with Numeric Data and Auto-Quoting", "Creating IN Lists with Duplicate Removal", "Bulk UPDATE Statements", "Sample Data", "Function Reference", "casewhen() - CASE Statement Generator", "inlist() - IN Statement Generator", "updatetable() - UPDATE Statement Generator", "Common Parameters Explained", "Installation", "Acknowledgments", "Citation and License" ], "created": "2023-11-25 02:33:43", "modified": "2025-09-09 07:20:02", "commits": 2 } ], "_score": 2.6989700043360187, "_indexed": true, "_nocasepkg": "sqlcaser", "_universes": [ "cran" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.1", "date": "2026-05-07T07:37:29.000Z", "distro": "noble", "commit": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "fileid": "fd8a6cdc2214829ae680d0d082b26f8c3a9ab9f716ffba5c53f7e7e5fdd994ed", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/25482423036" }, { "r": "4.6.0", "os": "linux", "version": "0.2.1", "date": "2026-05-07T07:38:08.000Z", "distro": "noble", "commit": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "fileid": "12e48749d32146a168e0509040e137f4e0bb42833e593ffeda76ad25a4582450", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/25482423036" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.1", "date": "2026-05-22T14:59:55.000Z", "commit": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "fileid": "ce2c0e9eddeb249b9ea5f66d700af6a380ede4752dedad8f7d31c413f9c5fad0", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/25482423036" } ] }