{ "_id": "6aacf0183d719c1f840734a8", "Package": "Query", "Title": "Write SQL Statements with ease", "Version": "0.0.1.300", "Authors@R": "person(\ngiven = \"Flippie\",\nfamily = \"Coetser\",\nrole = c(\"aut\", \"cre\"),\nemail = \"flippie.coetser@gmail.com\",\ncomment = c(ORCID = \"0000-0003-0549-9245\")\n)", "Description": "This package provides a set of utility functions to\nefficiently write SQL Statements: In essence converting R to\nSQL.", "License": "file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.2.3", "Config/testthat/edition": "3", "Repository": "https://flippiecoetser.r-universe.dev", "Date/Publication": "2023-10-08 17:37:48 UTC", "RemoteUrl": "https://github.com/FlippieCoetser/Query", "RemoteRef": "HEAD", "RemoteSha": "755509bb6dc436b04afbfef3133ba689357ec582", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-18 07:25:55 UTC", "User": "root" }, "Author": "Flippie Coetser [aut, cre] (ORCID:\n)", "Maintainer": "Flippie Coetser ", "_user": "flippiecoetser", "_type": "src", "_file": "Query_0.0.1.300.tar.gz", "_fileid": "https://r2.ropensci.org/90cfdece230e5436b341a9c2d64a66a5f026e69806fe1e5419e6b51bb97d7b72", "_filesize": 94338, "_sha256": "90cfdece230e5436b341a9c2d64a66a5f026e69806fe1e5419e6b51bb97d7b72", "_expires": "2026-12-27T08:02:30.000Z", "_created": "2026-09-18T07:25:55.000Z", "_published": "2026-09-18T08:02:32.227Z", "_jobs": [ { "job": 105518279318, "time": 110, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10535734846" }, { "job": 105518279340, "time": 105, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10536830455" }, { "job": 105518279362, "time": 95, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10537901972" }, { "job": 105518279333, "time": 82, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10537567150" }, { "job": 105517630835, "time": 148, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10535729813" }, { "job": 105518279281, "time": 95, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10536676927" }, { "job": 105518279487, "time": 69, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10536507090" }, { "job": 105518279406, "time": 63, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10536527158" }, { "job": 105518279465, "time": 58, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10536412329" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606", "_status": "success", "_upstream": "https://github.com/FlippieCoetser/Query", "_commit": { "id": "755509bb6dc436b04afbfef3133ba689357ec582", "author": "Flippie Coetser ", "committer": "GitHub ", "message": "Update README.md", "time": 1696786668 }, "_maintainer": { "name": "Flippie Coetser", "email": "flippie.coetser@gmail.com", "login": "flippiecoetser", "description": "\n", "uuid": 3672126, "orcid": "0000-0003-0549-9245" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "flippiecoetser", "_selfowned": true, "_usedby": 1, "_updates": [], "_tags": [], "_stars": 2, "_contributors": [ { "user": "flippiecoetser", "count": 662, "uuid": 3672126 } ], "_userbio": { "uuid": 3672126, "type": "user", "name": "Flippie Coetser", "followers": 0 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/Query" }, "_devurl": "https://github.com/flippiecoetser/query", "_searchresults": 1252, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/Query.html", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_cranurl": false, "_exports": [ "SQL", "SQL.Functions", "SQL.Functions.Service", "SQL.Orchestration", "SQL.Utilities", "SQL.Utility.Service" ], "_help": [ { "page": "DML.Service", "title": "Data Manipulating Language", "topics": [ "DML.Service" ] }, { "page": "DQL.Service", "title": "Data Query Language'", "topics": [ "DQL.Service" ] }, { "page": "SQL", "title": "SQL Statement Generator", "topics": [ "SQL" ] }, { "page": "SQL.Functions", "title": "SQL Functions", "topics": [ "SQL.Functions" ] }, { "page": "SQL.Functions.Service", "title": "SQL Functions'", "topics": [ "SQL.Functions.Service" ] }, { "page": "SQL.Orchestration", "title": "SQL Orchestration Service", "topics": [ "SQL.Orchestration" ] }, { "page": "SQL.Utilities", "title": "SQL Utility Functions", "topics": [ "SQL.Utilities" ] }, { "page": "SQL.Utility.Service", "title": "Helper Utilities", "topics": [ "SQL.Utility.Service" ] } ], "_readme": "https://github.com/FlippieCoetser/Query/raw/HEAD/README.md", "_rundeps": [], "_score": 4.574725583594073, "_indexed": true, "_nocasepkg": "query", "_universes": [ "flippiecoetser" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.1.300", "date": "2026-09-18T07:27:52.000Z", "distro": "resolute", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "https://r2.ropensci.org/f6f1911ffada5ba26fc27c204f9d40fe9dbdb4aea05d13d74dd227422d82eabb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606" }, { "r": "4.6.1", "os": "linux", "version": "0.0.1.300", "date": "2026-09-18T07:27:49.000Z", "distro": "resolute", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "https://r2.ropensci.org/451f8f0095c1b9c91cc38344c831ffd8a9a58ac042e62402d4e0da0ee644e04b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606" }, { "r": "4.5.3", "os": "mac", "version": "0.0.1.300", "date": "2026-09-18T08:01:58.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "https://r2.ropensci.org/237ec58e252a55eab0c73d46f5cc0e79daec974cee50623771ff86eef0641c7c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606" }, { "r": "4.6.1", "os": "mac", "version": "0.0.1.300", "date": "2026-09-18T07:59:43.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "https://r2.ropensci.org/5f411c508608e6edf9abfe9d51d96f147e21f9fc9f1a336c0e4de0eadccdf771", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.1.300", "date": "2026-09-18T07:27:44.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "https://r2.ropensci.org/3b6ba4afed477396d8584e6d1550b78293056c16543f753742334a4063fc2f08", "status": "success", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606" }, { "r": "4.7.0", "os": "win", "version": "0.0.1.300", "date": "2026-09-18T07:27:00.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "https://r2.ropensci.org/fa12c63fe50360257445a20210311e3885cffc1b54f7022b5a1542b9d70d28f5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606" }, { "r": "4.5.3", "os": "win", "version": "0.0.1.300", "date": "2026-09-18T07:26:56.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "https://r2.ropensci.org/0983389806d8790f938dcb41df8085e4c408f695681ba635c0a9a4d6ebf302a3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606" }, { "r": "4.6.1", "os": "win", "version": "0.0.1.300", "date": "2026-09-18T07:26:52.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "https://r2.ropensci.org/31afc5ea4e3d6644b871c6438e63a281111dbf47e63ef495c44a161542d01b9a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/35319132606" } ] }