{ "_id": "6acbb1ecfe5cc25786e92750", "Package": "lazysql", "Type": "Package", "Title": "Lazy SQL Programming", "Version": "0.1.3.9000", "Date": "2016-03-11", "Description": "Helper functions to build SQL statements under program\ncontrol for dbGetQuery, dbSendQuery, sqldf, etc. They are\nintended to increase speed of coding and to reduce coding\nerrors. Arguments are carefully checked, in particular SQL\nidentifiers such as names of tables or columns. More patterns\nwill be added as required.", "Authors@R": "person(\"Uwe\", \"Block\", email = \"u.block.mz@gmail.com\",\nrole = c(\"aut\", \"cre\"))", "URL": "https://github.com/UweBlock/lazysql", "BugReports": "https://github.com/UweBlock/lazysql/issues", "License": "MIT + file LICENSE", "RoxygenNote": "5.0.1", "Repository": "https://uweblock.r-universe.dev", "Date/Publication": "2016-03-16 06:39:59 UTC", "RemoteUrl": "https://github.com/uweblock/lazysql", "RemoteRef": "HEAD", "RemoteSha": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-11 15:48:25 UTC", "User": "root" }, "Author": "Uwe Block [aut, cre]", "Maintainer": "Uwe Block ", "_user": "uweblock", "_type": "src", "_file": "lazysql_0.1.3.9000.tar.gz", "_fileid": "https://r2.ropensci.org/ccb1931fdee17f7e4c20723811d3bbb19a4a881321683a15cd84193ad37af886", "_filesize": 99990, "_sha256": "ccb1931fdee17f7e4c20723811d3bbb19a4a881321683a15cd84193ad37af886", "_expires": "2027-01-19T15:57:30.000Z", "_created": "2026-10-11T15:48:25.000Z", "_published": "2026-10-11T15:57:32.130Z", "_buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 114509675462, "time": 109, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11707157975" }, { "job": 114509675385, "time": 85, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11706744114" }, { "job": 114509675386, "time": 171, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11707443028" }, { "job": 114509675390, "time": 138, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11707043243" }, { "job": 114509093780, "time": 164, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11707615853" }, { "job": 114509675297, "time": 73, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11707685803" }, { "job": 114509675360, "time": 54, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11706958265" }, { "job": 114509675389, "time": 50, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11707046973" }, { "job": 114509675416, "time": 63, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11707367295" } ], "_upstream": "https://github.com/uweblock/lazysql", "_commit": { "id": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "author": "Uwe Block ", "committer": "Uwe Block ", "message": "Make package docs consistent, mention sqldf as beneficiary. Closing #2.\n", "time": 1458110399 }, "_maintainer": { "name": "Uwe Block", "email": "u.block.mz@gmail.com", "login": "uweblock", "description": "", "uuid": 968678 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "checkmate", "version": ">= 1.7.2", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "plyr", "role": "Imports" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "uweblock", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 9, "_contributors": [ { "user": "uweblock", "count": 43, "uuid": 968678 } ], "_userbio": { "uuid": 968678, "type": "user", "name": "Uwe Block", "followers": 9 }, "_downloads": { "count": 239, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/lazysql" }, "_devurl": "https://github.com/uweblock/lazysql", "_searchresults": 8, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/lazysql.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/uweblock/lazysql", "_realowner": "uweblock", "_cranurl": true, "_releases": [ { "version": "0.1.3", "date": "2016-03-12" } ], "_exports": [ "date_between", "in_condition", "natural_key", "valid_identifier_regex" ], "_help": [ { "page": "date_between", "title": "Create SQL string to select date between two given dates", "topics": [ "date_between" ] }, { "page": "in_condition", "title": "Create SQL string to select values included in a set of given values", "topics": [ "in_condition" ] }, { "page": "lazysql", "title": "Lazy SQL programming", "topics": [ "lazysql-package", "lazysql" ] }, { "page": "natural_key", "title": "Create SQL string for joining on matching natural keys", "topics": [ "natural_key" ] }, { "page": "valid_identifier_regex", "title": "Regex pattern to validate SQL identifier names", "topics": [ "valid_identifier_regex" ] } ], "_readme": "https://github.com/uweblock/lazysql/raw/HEAD/README.md", "_rundeps": [ "backports", "checkmate", "magrittr", "plyr", "Rcpp" ], "_score": 3.6532125137753435, "_indexed": true, "_nocasepkg": "lazysql", "_universes": [ "uweblock" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.3.9000", "date": "2026-10-11T15:50:21.000Z", "distro": "resolute", "commit": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "fileid": "https://r2.ropensci.org/91f32fa0a8d8cc81155cad5fb072dd6da3f95e09ccff926066ae88d1150eefda", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567" }, { "r": "4.6.1", "os": "linux", "version": "0.1.3.9000", "date": "2026-10-11T15:49:56.000Z", "distro": "resolute", "commit": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "fileid": "https://r2.ropensci.org/da57f28a9e558b46f7b0a258d4252baacb31c3b4bee083d6efbd67bbc7b38fb1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567" }, { "r": "4.5.3", "os": "mac", "version": "0.1.3.9000", "date": "2026-10-11T15:56:09.000Z", "commit": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "fileid": "https://r2.ropensci.org/c0314f84eb33abd519e44d96156d583e8038a68e25549c64333de3f7d39ff459", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567" }, { "r": "4.6.1", "os": "mac", "version": "0.1.3.9000", "date": "2026-10-11T15:51:27.000Z", "commit": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "fileid": "https://r2.ropensci.org/770044e0f3725f3d509652f86306366ec73d8e271d2b0e7b026894ce9f2870cd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.3.9000", "date": "2026-10-11T15:49:57.000Z", "commit": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "fileid": "https://r2.ropensci.org/8ffad86b3a07f501102c4d05ec4b21d0a0979dd871a65ca6f69ede517fd566ef", "status": "success", "buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567" }, { "r": "4.7.0", "os": "win", "version": "0.1.3.9000", "date": "2026-10-11T15:49:22.000Z", "commit": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "fileid": "https://r2.ropensci.org/287483a67639652064d19f334524a559656e54539c9dd77faf44fd7335cd3dcd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567" }, { "r": "4.5.3", "os": "win", "version": "0.1.3.9000", "date": "2026-10-11T15:49:20.000Z", "commit": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "fileid": "https://r2.ropensci.org/4c36ff0eea42fe0e2e464c9945f327795746688b6346243d47f570209c3a7c50", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567" }, { "r": "4.6.1", "os": "win", "version": "0.1.3.9000", "date": "2026-10-11T15:49:29.000Z", "commit": "c6622f65d2a12ef434e6e5955f56f105b78956a7", "fileid": "https://r2.ropensci.org/455ce0b5fb5a3070cd1f9056df2f554f0b0a206b0d0d7cc51175113a87443f40", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/uweblock/actions/runs/38152623567" } ] }