Skip to content

rquery

1.4.99

Relational Query Generator for Data Manipulation at Scale

4packages depend
47.7Kdownloads / year
46.4%test coverage
0/13checks pass

Overview

About
Maintained by John MountFirst published 2018-01-2436 releasesCRAN page ↗GitHub ↗

A piped query generator based on Edgar F. Codd's relational algebra, and on production experience using 'SQL' and 'dplyr' at big data scale. The design represents an attempt to make 'SQL' more teachable by denoting composition by a sequential pipeline notation instead of nested queries or functions. The implementation delivers reliable high performance data processing on large data systems such as 'Spark', databases, and 'data.table'. Package features include: data processing trees or pipelines as observable objects (able to report both columns produced and columns used), optimized 'SQL' generation as an explicit user visible table modeling step, plus explicit query reasoning and checking.

Install

Health

CRAN checks
13NOTE
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
  • NOTE r-oldrel-macos-arm64
  • NOTE r-oldrel-macos-x86_64
  • NOTE r-oldrel-windows-x86_64
  • NOTE r-patched-linux-x86_64
  • NOTE r-release-linux-x86_64
  • NOTE r-release-macos-arm64
  • NOTE r-release-macos-x86_64
  • NOTE r-release-windows-x86_64
Slowest check: 2.9 min · r-oldrel-windows-x86_64
Code health
Yes
Tests · ratio 0.00
46.4%
Coverage · measured lines
100%
Documentation · exports
4
Dependencies · direct
Check history
  • NOTE2026-03-10
    0 OK · 14 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

Documentation
READMEYes · 2,140 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo
Examples that run
100%
Documented parameters
100%
Return-value docs
95%
References docs
0%

Downloads

47.7K
CRAN downloads in the past year
Rank #2,310 · ~131/day · ~4K/mo
Daily download trend is not available in this view yet.
2.9K30 days
8.2K90 days
47.7K1 year
Compare downloads with other packages →
Also on116 r2u31 autocran49 c2d4u

Repository

Repository
109Stars
15Forks
1Open issues
0Open PRs
33Releases
1,232Commits
3Contributors
1,232 commits · Last activity 2023-08-20

Stars over time

2025-01-02 · 1092026-07-07 · 109

Repository practices

Upstream repositoryBeta

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

Checks run against github.com/winvector/rquery on 2026-08-16.

CRAN release process (1)
cran-comments.md
Docs source (1)
README.Rmd
Lint, format, editor (1)
RStudio project
How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies
9 external dependencies (excludes base and recommended)
Depends (2)
R >= 3.4.0wrapr
Imports (3)
utilsstatsmethods
LinkingTo (0)
none
Enhances (0)
none
Reverse dependencies
4direct
0indirect

Code & Tests

People & History

People (2)
Maintainer (1)
Author, Maintainer
Authors (1)
Author, Maintainer
Copyright holders (1)
Copyright holder
Package Timeline

36 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
  • 1.4.99Latest
    2023-08-20 · current release · diff ↗
  • R
    R 4.3.0 released · 2023-04-21
  • R
    R 4.2.0 released · 2022-04-22
  • 1.4.9
    2022-02-28 · diff ↗
  • 1.4.8
    2022-01-22 · diff ↗
  • 1.4.7
    2021-06-10 · diff ↗
  • R
    R 4.1.0 released · 2021-05-18
  • 1.4.6
    2020-10-17 · diff ↗
  • 1.4.5
    2020-08-12 · diff ↗
  • R
    R 4.0.0 released · 2020-04-24
  • 1.4.4
    2020-02-18 · diff ↗
  • 1.4.3
    2020-02-01 · diff ↗
  • 1.4.2
    2020-01-19 · diff ↗
Show 30 earlier events

Package metadata

First published
2018-01-24
Total releases
36 / 8 yrs
License
GPL-2 | GPL-3 OSI
Minimum R
≥ 3.4.0
Download size
489 KB
Installed size
not tracked yet
With dependencies
not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("rquery")
Mount, J., & Win-Vector LLC, . (2023). rquery: Relational Query Generator for Data Manipulation at Scale (Version 1.4.99) [Computer software]. https://doi.org/10.32614/CRAN.package.rquery

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

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

APA

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

From data release v2026-08-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 →

Privacy choices

These apply to this browser and are stored on this device only. Nothing about your choice is sent to us.

Read the privacy policy