{ "_id": "6a1f1883b401979e7341ed44", "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-05-17 05:40:49 UTC", "User": "root" }, "Author": "Ian Cook [aut, cre],\nCloudera [cph]", "MD5sum": "42c3cd8a77f1c9adfcffd8ee9375190a", "_user": "ianmcook", "_type": "src", "_file": "tidyquery_0.2.4.9000.tar.gz", "_fileid": "cc989a35ee95b1cf229d28e9a8af658e519ca4530a8dc38ab98d5d91c1aa44f8", "_filesize": 130890, "_sha256": "cc989a35ee95b1cf229d28e9a8af658e519ca4530a8dc38ab98d5d91c1aa44f8", "_created": "2026-05-17T05:40:49.000Z", "_published": "2026-06-02T17:53:07.642Z", "_distro": "noble", "_jobs": [ { "job": 79136614513, "time": 158, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7039708565" }, { "job": 79136614490, "time": 159, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7039708759" }, { "job": 79136615119, "time": 151, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7039704747" }, { "job": 79136614402, "time": 204, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7039709494" }, { "job": 79136613829, "time": 144, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7039690097" }, { "job": 79136614059, "time": 108, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7365663176" }, { "job": 79136614372, "time": 120, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7039705388" }, { "job": 79136616022, "time": 117, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7039703625" }, { "job": 79136615313, "time": 124, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7039704681" } ], "_buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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": 167, "_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", "description": "Accelerating data connectivity with Apache Arrow" }, "_downloads": { "count": 308, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/tidyquery" }, "_devurl": "https://github.com/ianmcook/tidyquery", "_searchresults": 38, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/tidyquery.html", "manual.pdf" ], "_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.978591326820075, "_indexed": true, "_nocasepkg": "tidyquery", "_universes": [ "ianmcook" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.4.9000", "date": "2026-05-17T05:43:03.000Z", "distro": "noble", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "2ba97c919e1b473139bfa788b75e715f7591560c93f02418b5d2ebb15c2b32cc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434" }, { "r": "4.6.0", "os": "linux", "version": "0.2.4.9000", "date": "2026-05-17T05:43:03.000Z", "distro": "noble", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "95017b98da1461bb8d616461d84359dfd288e8e4d254f7dbef57c9c9fa91c9a1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434" }, { "r": "4.5.3", "os": "mac", "version": "0.2.4.9000", "date": "2026-05-17T05:42:45.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "be422d607cbd0228d158119e478e02d9c41cf10716513013a24b8c57895f251b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434" }, { "r": "4.6.0", "os": "mac", "version": "0.2.4.9000", "date": "2026-05-17T05:43:10.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "b8d4f0f80fbe2d272d4efd3cf9d9c532e90fa1bed982050cf0b54e278dd7233d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434" }, { "r": "4.7.0", "os": "win", "version": "0.2.4.9000", "date": "2026-05-17T05:42:20.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "4c8d73f40afe0deae647df3871947409718298515918fbf5243033a52e71395d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434" }, { "r": "4.5.3", "os": "win", "version": "0.2.4.9000", "date": "2026-05-17T05:42:03.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "fb85640ad460e111c3c38207f09328d3aaa947ddc2791824eb6b68ec43676210", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434" }, { "r": "4.6.0", "os": "win", "version": "0.2.4.9000", "date": "2026-05-17T05:42:14.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "767e2b504b21bb119ff5acadb4ac4a99e48aa0f6c03bd4af3330ac3038ec2f91", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.4.9000", "date": "2026-06-02T17:52:47.000Z", "commit": "7c201d6cbade64383610b525291ec5c0ba7baaf7", "fileid": "11d7434884ec999c7dd46898c216ccd27fb39f49f8860bde1ec0a6f937b28bd6", "status": "success", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25982569434" } ] }