{ "_id": "6ac355bbd743750d376da682", "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-10-05 07:43:42 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", "_user": "cran", "_type": "src", "_file": "sqlcaser_0.2.1.tar.gz", "_fileid": "https://r2.ropensci.org/97263c5f4a3897dc2b3b1b158b6c788deac63158e42a14f5c63179dfd4c5c991", "_filesize": 105071, "_sha256": "97263c5f4a3897dc2b3b1b158b6c788deac63158e42a14f5c63179dfd4c5c991", "_expires": "2027-01-13T07:46:01.000Z", "_created": "2026-10-05T07:43:42.000Z", "_published": "2026-10-05T07:46:03.081Z", "_jobs": [ { "job": 111663643682, "time": 100, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11331164444" }, { "job": 111663643802, "time": 92, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11331791945" }, { "job": 111662909307, "time": 147, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11331403292" }, { "job": 111663643836, "time": 71, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11331945033" }, { "job": 111663643787, "time": 58, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11331219136" }, { "job": 111663643724, "time": 60, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11331154420" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/cran/actions/runs/37279116709", "_status": "success", "_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" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 631, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 310, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlcaser" }, "_searchresults": 2, "_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/sqlcaser.html", "LICENSE" ], "_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-10-05T07:45:28.000Z", "distro": "resolute", "commit": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "fileid": "https://r2.ropensci.org/d4ee52ecba55e2b4abd0ef7863ab811d11fb1abec95c3e698df8ef274e842e38", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/37279116709" }, { "r": "4.6.1", "os": "linux", "version": "0.2.1", "date": "2026-10-05T07:45:22.000Z", "distro": "resolute", "commit": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "fileid": "https://r2.ropensci.org/a30b9dd29ba56dadb48a77b10d4df5d913a0bf5c40f3168c0f4002dc0fd24995", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/37279116709" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.1", "date": "2026-10-05T07:45:14.000Z", "commit": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "fileid": "https://r2.ropensci.org/6f9e09ac59ea1e45270e3eae9b60efa59f6ef9c422f388cff887c5e608d96b8b", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/37279116709" }, { "r": "4.7.0", "os": "win", "version": "0.2.1", "date": "2026-10-05T07:44:43.000Z", "commit": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "fileid": "https://r2.ropensci.org/d3446269661e1c667047aed3d6b7b5beaa3efd646eebf215fbf51d0f6dd74ec1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/37279116709" }, { "r": "4.6.1", "os": "win", "version": "0.2.1", "date": "2026-10-05T07:44:48.000Z", "commit": "d64e34d9c9e96ef97dcfaedfd889f43d1ef85efd", "fileid": "https://r2.ropensci.org/f49ba1bb4de3fcec8594dc346fce2248b29d3d2977c0a0b132e60b865851b5d5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/37279116709" } ] }