R Observatory: Metrics for tidyquery version 0.2.4

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

tidyquery

0.2.4Package record

Query 'R' Data Frames with 'SQL'

0packages dependsuggested by 1

3.7Kdownloads / year

97.3%test coverage

8/13flavors OK

Overview

About

Maintained by Ian CookCRAN page ↗GitHub ↗Issues ↗

Use 'SQL' 'SELECT' statements to query 'R' data frames.

Changes in 0.2.4

Requires dplyr version 1.0.0 or higher
Supports cross joins (#11)
Works with Apache Arrow Table, RecordBatch, and Dataset objects through the arrow package (#16)
Continuous integration migrated to GitHub Actions (#28)
Generates the new join_by() syntax introduced in dplyr 1.1.0 if you set options(tidyquery.use_join_by = TRUE) (#30)
Other changes to support dplyr 1.1.0 (#29)

From NEWS.md in the release

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("tidyquery", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("ianmcook/tidyquery")

Development version from ianmcook/tidyquery. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-tidyquery

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-tidyquery

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-tidyquery

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

5NOTE8OK

Check messages

NOTER code for possible problemsr-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-devel-windows-x86_64

Found calls to structure() using deprecated special names:
  tidyquery/R/join.R (.Names: 10)
'.Names' should be changed to 'names'.

CRAN check page ↗

Slowest check: 2.6 min · r-release-macos-x86_64

Status changes

NOTE8 OK, 5 NOTENow
NOTE11 OK, 2 NOTE2026-07-16
OK13 OK2026-06-09
ERROR12 OK, 1 ERROR2026-06-08
OK14 OK2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.2.4

READMEYes · 555 wordsVignettesNoNEWSYes · 100% structured · mentions 0.2.4Citation fileNoWebsitenot declared in DESCRIPTION

Help pages: 2
Examples that run: 100%2 run in a plain check
Exported functions with examples: 100%
Documented parameters: 100%
Return-value docs: 50%
Help pages citing references: 0%

How these are measured

Downloads

3.7K

CRAN downloads in the past year

Rank #11,812 · ~10/day · ~312/mo

Releases R versions

Daily download trend is not available in this view yet.

35130 days

92290 days

3.7K1 year

Compare downloads with other packages →

Also on68 r2u2 autocran

How downloads are counted

Repository

ianmcook/tidyquery ↗Account: ianmcook

166Stars

12Forks

4Open issues

0Open PRs

4Releases

247Commits

5Commit identities

rsqltidyversedplyrquery

License file reads as Apache-2.0 · 247 commits · Last activity 2023-01-14 · 0% stars, 30d · Default branch at 0.2.4.9000, ahead of CRAN 0.2.4 (checked 2026-10-18)

Responsiveness

How these are sampled

PRs merged (all time): 67%
Median days to close, 50 most recently updated closed issues: 6
Median days to close, 50 most recently updated closed PRs: 4

Stars over time

2025-04-22 · 1652026-07-07 · 166

How these are measured

PracticesBeta

5 development-tooling and community-health practices detected across 4 families in the upstream repository

Checks run against github.com/ianmcook/tidyquery on 2026-10-18.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Docs source (1)

README.Rmd

Coverage (1)

Coverage reporting (Codecov)

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

Dependencies

Declared dependencies

14 external dependencies (excludes base and recommended)

Installing tidyquery adds 21 packages (12 with compiled code, 17 MB of source tarballs). Heaviest: stringi 11 MB, vctrs 1.0 MB, dplyr 902 KB.

Depends (0)

none

Imports (6)

dplyr lubridate queryparser (>= 0.3.2)rlang stringrutils

LinkingTo (0)

none

Suggests (9)

covr DBI dbplyr dtplyr (>= 1.0.0)arrow nycflights13 RSQLite testthat withr

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Suggested by 1

Suggests, most downloaded first

prqlr

How these are counted

Code & Tests

People & History

People (2)

Ian Cook

Author, Maintainer since 0.1.0 (2019)

Cloudera

Copyright holder

Releases (6)

Pick two releases to compare their code metrics.

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21
0.2.4Latest
record
2023-01-14 · current release · diff ↗
R
R 4.2.0 released · 2022-04-22
0.2.3
record
2021-12-02 · diff ↗ ·
added 1 export
.tidyquery.version
R
R 4.1.0 released · 2021-05-18
0.2.2
record
2021-02-06 · diff ↗ ·
added 1 export
.datatable.aware
0.2.1
record
2020-05-09 · diff ↗
R
R 4.0.0 released · 2020-04-24
0.2.0
record
2020-01-20 · diff ↗ ·
added 1 export
show_dplyr
0.1.0
record
2019-09-19
R
R 3.6.0 released · 2019-04-26

Package metadata

First published: 2019-09-19
Total releases: 6 / 7 yrs
License: Apache License 2.0 OSI
Download size: 44 KB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("tidyquery")

Format

Cook, I., & Cloudera, . (2023). tidyquery: Query 'R' Data Frames with 'SQL' (Version 0.2.4) [Computer software]. https://doi.org/10.32614/CRAN.package.tidyquery

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for tidyquery version 0.2.4 [Data set]. HJJB, LLC. Data release v2026-10-22. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-22, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →