{ "_id": "6a0f6c94acfb0bcc41c5e9a1", "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-05-21 08:16:38 UTC", "User": "root" }, "Author": "Flippie Coetser [aut, cre] (ORCID:\n)", "Maintainer": "Flippie Coetser ", "MD5sum": "e4118139fcfd45b186fb58aacb7a9f27", "_user": "flippiecoetser", "_type": "src", "_file": "Query_0.0.1.300.tar.gz", "_fileid": "03dfa0e69ac0b16a953bf92ab7a44627aba8b9c0b36a4c6260c75560a1f1058c", "_filesize": 94068, "_sha256": "03dfa0e69ac0b16a953bf92ab7a44627aba8b9c0b36a4c6260c75560a1f1058c", "_created": "2026-05-21T08:16:38.000Z", "_published": "2026-05-21T20:35:32.470Z", "_distro": "noble", "_jobs": [ { "job": 77263553982, "time": 116, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7130676641" }, { "job": 77263554193, "time": 98, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7130671149" }, { "job": 77263553989, "time": 80, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7130664851" }, { "job": 77263553973, "time": 90, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7130668185" }, { "job": 77263553729, "time": 143, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7130638593" }, { "job": 77263553312, "time": 86, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7146581588" }, { "job": 77263553836, "time": 69, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7130661319" }, { "job": 77263554334, "time": 60, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7130658670" }, { "job": 77263553882, "time": 87, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7130667379" } ], "_buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997", "_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" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/Query" }, "_devurl": "https://github.com/flippiecoetser/query", "_searchresults": 890, "_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", "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.426511261364575, "_indexed": true, "_nocasepkg": "query", "_universes": [ "flippiecoetser" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.1.300", "date": "2026-05-21T08:18:36.000Z", "distro": "noble", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "3968eec4ba749d3fc58afda4b8e84753fedf6bae69e296cf80c0ceb5a64a290b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997" }, { "r": "4.6.0", "os": "linux", "version": "0.0.1.300", "date": "2026-05-21T08:18:20.000Z", "distro": "noble", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "737c288243e45c26aab3646676b4b563202fcbb382266d0c7a5bd64e1312d187", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997" }, { "r": "4.5.3", "os": "mac", "version": "0.0.1.300", "date": "2026-05-21T08:18:03.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "662beab76eb325e88d7d6b78868a41a0e43c795d86649ad26127e45168f4dacb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997" }, { "r": "4.6.0", "os": "mac", "version": "0.0.1.300", "date": "2026-05-21T08:18:11.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "e623da6c97765609b09d279518fe63e0baf9b498d66ca2d821cc4c5e563d2daa", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.1.300", "date": "2026-05-21T20:35:16.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "bff69176f7c1dda4115e82ebf49efa11290ccfce78022476cec10a035531ba96", "status": "success", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997" }, { "r": "4.7.0", "os": "win", "version": "0.0.1.300", "date": "2026-05-21T08:17:44.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "b623fbb1cb15982dfbf19c6033e3219907441a2c0af9fa5b361b5a89d4e27f79", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997" }, { "r": "4.5.3", "os": "win", "version": "0.0.1.300", "date": "2026-05-21T08:17:35.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "70862f322a18a7cfa37d0ee038c45c719a69cf79ddb15e03bfbaee8d6053d659", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997" }, { "r": "4.6.0", "os": "win", "version": "0.0.1.300", "date": "2026-05-21T08:18:02.000Z", "commit": "755509bb6dc436b04afbfef3133ba689357ec582", "fileid": "a229d651e29be6213de130fa8cef69c03385eb2739abfa28bb7f6648bca6fd17", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/flippiecoetser/actions/runs/26214022997" } ] }