{ "_id": "6a364a563efcd9bda43ff4e7", "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-06-20 08:05:12 UTC", "User": "root" }, "Author": "Flippie Coetser [aut, cre] (ORCID:\n)", "Maintainer": "Flippie Coetser ", "MD5sum": "ac16259f5dd598d5c3baecc2858a00ce", "_user": "flippiecoetser", "_type": "src", "_file": "Query_0.0.1.300.tar.gz", "_fileid": "4d0c1439fed7e0a06965c271f71ed3c1a29dcf803e194d92f689b40e4966b6b1", "_filesize": 94469, "_sha256": "4d0c1439fed7e0a06965c271f71ed3c1a29dcf803e194d92f689b40e4966b6b1", "_created": "2026-06-20T08:05:12.000Z", "_published": "2026-06-20T08:07:50.213Z", "_distro": "noble", "_jobs": [ { "job": 82467804598, "time": 127, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7763519067" }, { "job": 82467804587, "time": 105, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7763516310" }, { "job": 82467804590, "time": 74, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7763511597" }, { "job": 82467804594, "time": 70, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7763511268" }, { "job": 82467645579, "time": 151, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7763501697" }, { "job": 82467804588, "time": 85, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7763513503" }, { "job": 82467804611, "time": 69, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7763511129" }, { "job": 82467804610, "time": 54, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7763509289" }, { "job": 82467804613, "time": 65, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7763510791" } ], "_buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670", "_status": "success", "_host": "GitHub-Actions", "_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" }, "_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": 1134, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/Query.html", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_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.53173430927655, "_indexed": true, "_nocasepkg": "query", "_universes": [ "flippiecoetser" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.1.300", "date": "2026-06-20T08:07:24.000Z", "distro": "noble", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "cbb0cd2b822ce478a8ab6c2f244c7a8f339d1a008e00fc14f183735818290c9b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670" }, { "r": "4.6.0", "os": "linux", "version": "0.0.1.300", "date": "2026-06-20T08:07:04.000Z", "distro": "noble", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "a4816616b0f4f5038f004124efc1bac7dd80c673ec972f6cd5dfb5e8cb8830dd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670" }, { "r": "4.5.3", "os": "mac", "version": "0.0.1.300", "date": "2026-06-20T08:06:33.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "778b626331a98655a3950f401e25f42d92bef94d77d6f4550aaf44815da97b0d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670" }, { "r": "4.6.0", "os": "mac", "version": "0.0.1.300", "date": "2026-06-20T08:06:31.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "a66166399d263f4b97e2f060689600a17c93e4b7978166ddd0a0582f6b395b18", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.1.300", "date": "2026-06-20T08:06:54.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "5cc309a8053998c7500925e72e9c133a26f04c665da46a0711c9ec9f84d64af2", "status": "success", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670" }, { "r": "4.7.0", "os": "win", "version": "0.0.1.300", "date": "2026-06-20T08:06:21.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "f59f4e828f7858575a6b5af43190a5ae3d59e3b62ec76ad9578d3ee6e2d803ab", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670" }, { "r": "4.5.3", "os": "win", "version": "0.0.1.300", "date": "2026-06-20T08:06:08.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "c5c66ad77e34665464c18e4917421e64d4013983232fa8c3e0cd3e43a8d7dd13", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670" }, { "r": "4.6.0", "os": "win", "version": "0.0.1.300", "date": "2026-06-20T08:06:19.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "a04c3593e607bd9e522978ac0d91fa654014e937a47a6b3d2adc949b1d969498", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/27865051670" } ] }