{ "_id": "6acf490cd9de2f3f33fca221", "Type": "Package", "Package": "tidyquery", "Title": "Query 'R' Data Frames with 'SQL'", "Version": "0.2.4.9000", "Authors@R": "c(person(given = \"Ian\",\nfamily = \"Cook\",\nrole = c(\"aut\", \"cre\"),\nemail = \"ianmcook@gmail.com\"),\nperson(family = \"Cloudera\",\nrole = \"cph\"))", "Maintainer": "Ian Cook ", "Description": "Use 'SQL' 'SELECT' statements to query 'R' data frames.", "License": "Apache License 2.0", "URL": "https://github.com/ianmcook/tidyquery", "BugReports": "https://github.com/ianmcook/tidyquery/issues", "Encoding": "UTF-8", "NeedsCompilation": "no", "RoxygenNote": "7.2.3", "Collate": "'compat.R' 'query.R' 'join.R' 'quote.R' 'remove.R' 'replace.R'\n'show_dplyr.R' 'unscope.R'", "Config/testthat/edition": "3", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://ianmcook.r-universe.dev", "Date/Publication": "2023-01-14 16:49:29 UTC", "RemoteUrl": "https://github.com/ianmcook/tidyquery", "RemoteRef": "HEAD", "RemoteSha": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "Packaged": { "Date": "2026-10-14 08:23:32 UTC", "User": "root" }, "Author": "Ian Cook [aut, cre],\nCloudera [cph]", "_user": "ianmcook", "_type": "src", "_file": "tidyquery_0.2.4.9000.tar.gz", "_fileid": "https://r2.ropensci.org/1d23b04069962905c16a98bcb8453fd15201f015813d8437e4a40aee82e22669", "_filesize": 130293, "_sha256": "1d23b04069962905c16a98bcb8453fd15201f015813d8437e4a40aee82e22669", "_expires": "2027-01-22T09:19:07.000Z", "_created": "2026-10-14T08:23:32.000Z", "_published": "2026-10-14T09:19:08.785Z", "_buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 115755032614, "time": 140, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "11879598180" }, { "job": 115755032610, "time": 147, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11879417540" }, { "job": 115755032582, "time": 145, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11881739265" }, { "job": 115755032692, "time": 118, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11881699352" }, { "job": 115753191565, "time": 286, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11878878049" }, { "job": 115755032720, "time": 89, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11879232792" }, { "job": 115755032742, "time": 114, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "11878814490" }, { "job": 115755032744, "time": 114, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11880046922" }, { "job": 115755032725, "time": 74, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11879996459" } ], "_upstream": "https://github.com/ianmcook/tidyquery", "_commit": { "id": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "author": "Ian Cook ", "committer": "Ian Cook ", "message": "Improve docs\n", "time": 1673714969 }, "_maintainer": { "name": "Ian Cook", "email": "ianmcook@gmail.com", "login": "ianmcook", "bluesky": "@ian.columnar.tech", "linkedin": "in/ianmcook", "twitter": "@ianmcook", "description": "Accelerating data connectivity with Apache Arrow", "uuid": 280509 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "dplyr", "version": ">= 1.0.0", "role": "Imports" }, { "package": "lubridate", "version": ">= 1.6.0", "role": "Imports" }, { "package": "queryparser", "version": ">= 0.3.2", "role": "Imports" }, { "package": "rlang", "version": ">= 0.4.9", "role": "Imports" }, { "package": "stringr", "version": ">= 1.0.0", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "covr", "version": ">= 3.2.0", "role": "Suggests" }, { "package": "DBI", "version": ">= 0.7", "role": "Suggests" }, { "package": "dbplyr", "version": ">= 1.2.1", "role": "Suggests" }, { "package": "dtplyr", "version": ">= 1.0.0", "role": "Suggests" }, { "package": "arrow", "version": ">= 10.0.0", "role": "Suggests" }, { "package": "nycflights13", "role": "Suggests" }, { "package": "RSQLite", "version": ">= 2.1.0", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "ianmcook", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "dplyr", "query", "sql", "tidyverse" ], "_stars": 166, "_contributors": [ { "user": "ianmcook", "count": 69, "uuid": 280509 }, { "user": "indrajeetpatil", "count": 4, "uuid": 11330453 }, { "user": "eitsupi", "count": 4, "uuid": 50911393 }, { "user": "lionel-", "count": 1, "uuid": 4465050 } ], "_userbio": { "uuid": 280509, "type": "user", "name": "Ian Cook", "followers": 177, "description": "Accelerating data connectivity with Apache Arrow" }, "_downloads": { "count": 339, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/tidyquery" }, "_devurl": "https://github.com/ianmcook/tidyquery", "_searchresults": 39, "_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/tidyquery.html" ], "_homeurl": "https://github.com/ianmcook/tidyquery", "_realowner": "ianmcook", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2019-09-19" }, { "version": "0.2.0", "date": "2020-01-20" }, { "version": "0.2.1", "date": "2020-05-09" }, { "version": "0.2.2", "date": "2021-02-06" }, { "version": "0.2.3", "date": "2021-12-02" }, { "version": "0.2.4", "date": "2023-01-14" } ], "_exports": [ ".datatable.aware", ".tidyquery.version", "query", "show_dplyr" ], "_help": [ { "page": "query", "title": "Query an R data frame with SQL", "topics": [ "query" ] }, { "page": "show_dplyr", "title": "Show dplyr code equivalent to a SQL query", "topics": [ "show_dplyr" ] } ], "_pkglogo": "https://github.com/ianmcook/tidyquery/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/ianmcook/tidyquery/raw/HEAD/README.md", "_rundeps": [ "cli", "cpp11", "dplyr", "generics", "glue", "lifecycle", "lubridate", "magrittr", "pillar", "pkgconfig", "queryparser", "R6", "rlang", "stringi", "stringr", "tibble", "tidyselect", "timechange", "utf8", "vctrs", "withr" ], "_score": 5.987263954122235, "_indexed": true, "_nocasepkg": "tidyquery", "_universes": [ "ianmcook" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.4.9000", "date": "2026-10-14T08:25:35.000Z", "distro": "resolute", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "https://r2.ropensci.org/de9a0827b01cd0ac79dcf951b8c04fb6bd70395db141fdf0a2ede2998cfa1215", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152" }, { "r": "4.6.1", "os": "linux", "version": "0.2.4.9000", "date": "2026-10-14T08:25:38.000Z", "distro": "resolute", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "https://r2.ropensci.org/eb529c14430a76864bdde4a41053f15a2922df68932dc6716f51b652226decc5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152" }, { "r": "4.5.3", "os": "mac", "version": "0.2.4.9000", "date": "2026-10-14T09:17:57.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "https://r2.ropensci.org/d05b8421941b77a67eb7314f473d0cf59b89044e1853a1ba472d821df6e2ab4a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152" }, { "r": "4.6.1", "os": "mac", "version": "0.2.4.9000", "date": "2026-10-14T09:18:11.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "https://r2.ropensci.org/02acd9a10153d713a082f8dea247851d2d8ebc36688c3e5954ac7b796fbf3e35", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.4.9000", "date": "2026-10-14T08:25:24.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "https://r2.ropensci.org/017a92d54684a0dde4b27d848c7659f21cd998a6bcb876e469721a69b41fd4f6", "status": "success", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152" }, { "r": "4.7.0", "os": "win", "version": "0.2.4.9000", "date": "2026-10-14T08:24:46.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "https://r2.ropensci.org/3cf188b875d4e9ad185ed87f355051b618f63095585560ac3eba406e5968ad70", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152" }, { "r": "4.5.3", "os": "win", "version": "0.2.4.9000", "date": "2026-10-14T08:24:53.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "https://r2.ropensci.org/3ea40be043cdcba6befc1a539ee6dcdb881171b0846295f8178ac418cec3c4d0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152" }, { "r": "4.6.1", "os": "win", "version": "0.2.4.9000", "date": "2026-10-14T08:24:34.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "https://r2.ropensci.org/7fb203abfdddf003651fff057dccef0c1d738a89afbb14f661cf67c64737fb5b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38534215152" } ] }