tidyquery

0.2.4

Query 'R' Data Frames with 'SQL'

1packages depend

4.3Kdownloads / year

97.3%test coverage

8/13checks pass

Overview

About

Maintained by Ian CookFirst published 2019-09-196 releasesCRAN page ↗GitHub ↗

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

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.

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).

Health

CRAN checks

5NOTE8OK

Failing flavors

NOTE r-devel-linux-x86_64-debian-clang
NOTE r-devel-linux-x86_64-debian-gcc
NOTE r-devel-linux-x86_64-fedora-clang
NOTE r-devel-linux-x86_64-fedora-gcc
NOTE r-devel-windows-x86_64

Slowest check: 2.7 min · r-oldrel-windows-x86_64

Code health

Yes

Tests · ratio 2.06

97.3%

Coverage · measured lines

50%

Documentation · exports

Dependencies · direct

Check history

NOTE2026-07-16
11 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-06-09
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-06-08
12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 555 wordsVignettesNopkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: 100%
Return-value docs: 50%
References docs: 0%

Downloads

4.3K

CRAN downloads in the past year

Rank #10,983 · ~12/day · ~355/mo

Releases R versions

Daily download trend is not available in this view yet.

26130 days

92790 days

4.3K1 year

Compare downloads with other packages →

Also on98 r2u2 autocran

Repository

GitHub ↗ ianmcook/tidyquery

166Stars

12Forks

4Open issues

0Open PRs

4Releases

247Commits

5Contributors

rsqltidyversedplyrquery

License Apache-2.0 · 247 commits · Last activity 2023-01-14 · 0% stars, 30d

Stars over time

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

Repository practices

Upstream repositoryBeta

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

Checks run against github.com/ianmcook/tidyquery on 2026-07-31.

Continuous integration (1)

GitHub Actions

Docs source (1)

README.Rmd

Lint, format, editor (1)

RStudio project

Coverage (1)

Codecov

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

14 external dependencies (excludes base and recommended)

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

1direct

0indirect

prqlr

Code & Tests

People & History

People (2)

Maintainer (1)

Ian Cook

Author, Maintainer

Authors (1)

Ian Cook

Author, Maintainer

Cloudera

Package Timeline

6 releases. Pick two to compare their code metrics. R releases are shown for context.

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
2023-01-14 · current release · diff ↗
R
R 4.2.0 released · 2022-04-22
0.2.3
2021-12-02 · diff ↗
R
R 4.1.0 released · 2021-05-18
0.2.2
2021-02-06 · diff ↗
0.2.1
2020-05-09 · diff ↗
R
R 4.0.0 released · 2020-04-24
0.2.0
2020-01-20 · diff ↗
0.1.0
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
Installed size: not tracked yet
With dependencies: not tracked yet

Report a problem with this page →