Skip to content

tidyquery

Query 'R' Data Frames with 'SQL'

v0.2.4 · Jan 14, 2023 · Apache License 2.0

Description

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

Downloads

CRAN

353

Last 30 days

11237th

967

Last 90 days

4.3K

Last year

Trend: +17.3% (30d vs prior 30d)

r2u CRAN

9

Last 30 days

25

Last 90 days

104

Last year

Trend: -40% (30d vs prior 30d)

autoCRAN

2

Last 7 days

12

Last 30 days

0

All-time

autoCRAN-only: this name is served only by autoCRAN, so the count is exact.

CRAN Check Status

13 OK
Show all 13 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Jun 9, 2026
ERROR 12 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Jun 8, 2026
ERROR r-devel-linux-x86_64-debian-gcc

tests

Running ‘testthat.R’ [1s/1s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(tidyquery)
  > 
  > test_check("tidyquery")
  Error in `source_dir()`:
  ! Failed to evaluate './setup-load_data.R'.
  Cau
...[truncated]...
 └─base::library(dbplyr)
   17. │                         └─base::stop(packageNotFoundError(package, lib.loc, sys.call()))
   18. └─testthat (local) `<fn>`(`<pckgNtFE>`)
   19.   └─cli::cli_abort(...)
   20.     └─rlang::abort(...)
  Execution halted
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Reverse Dependencies (1)

suggests

Dependency Network

Dependencies Reverse dependencies dplyr lubridate queryparser (>= 0.3.2) rlang stringr prqlr tidyquery

Version History

7 tracked
new 0.2.4 Mar 10, 2026
updated 0.2.4 ← 0.2.3 diff Jan 13, 2023
updated 0.2.3 ← 0.2.2 diff Dec 1, 2021
updated 0.2.2 ← 0.2.1 diff Feb 5, 2021
updated 0.2.1 ← 0.2.0 diff May 8, 2020
updated 0.2.0 ← 0.1.0 diff Jan 19, 2020
new 0.1.0 Sep 18, 2019