R Observatory: Metrics for rquery version 1.5.1

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

rquery

1.5.1Package record

Relational Query Generator for Data Manipulation at Scale

3packages dependsuggested by 1

37.9Kdownloads / year

46.4%test coverage

13/13flavors OK

Overview

About

Maintained by John MountCRAN page ↗GitHub ↗Website ↗Issues ↗

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.

Changes in 1.5.1

Fix brace issue in docs.

From NEWS.md in the release

Install

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

install.packages("rquery", 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("WinVector/rquery")

Development version from WinVector/rquery. 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-rquery

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-rquery

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-rquery

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

13OK

CRAN check page ↗

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

Status changes

OK13 OK2026-09-25
NOTE14 NOTE2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 1.5.1

READMEYes · 2,156 wordsVignettesYes · 8 · dynamicNEWSYes · 100% structured · mentions 1.5.1Citation fileNoWebsiteYes · pkgdown

Help pages: 109 (13 internal)includes a package overview page
Examples that run: 100%70 run in a plain check (62 of them under a condition)
Exported functions with examples: 68%
Documented parameters: 100%
Return-value docs: 95%
Help pages citing references: 0%

Vignettes (8)

How these are measured

Downloads

37.9K

CRAN downloads in the past year

Rank #2,246 · ~104/day · ~3.2K/mo

Releases R versions

Daily download trend is not available in this view yet.

2.6K30 days

7.6K90 days

37.9K1 year

Compare downloads with other packages →

Also on146 r2u4 autocran109 c2d4u

How downloads are counted

Repository

winvector/rquery ↗Organization: WinVector

109Stars

16Forks

1Open issues

0Open PRs

33Releases

1,237Commits

4Commit identities

1,237 commits · Last activity 2026-09-08

Responsiveness

How these are sampled

PRs merged (all time): 100%
Median days to close, 50 most recently updated closed issues: 0
Median days to close, 50 most recently updated closed PRs: 0

Stars over time

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

How these are measured

PracticesBeta

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

Checks run against github.com/winvector/rquery on 2026-10-22.

Docs source (3)

README.Rmdpkgdown

GitHub Pages site last deployed 2022-01-27

CRAN release process (1)

cran-comments.md

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v4 (2026-10-20)

Dependencies

Declared dependencies

9 external dependencies (excludes base and recommended)

Installing rquery adds 1 package (0 with compiled code, 552 KB of source tarballs). Heaviest: wrapr 552 KB.

Depends (2)

R >= 3.4.0wrapr

Imports (3)

utilsstatsmethods

LinkingTo (0)

none

Suggests (8)

DBI RSQLite rqdatatable igraph knitr rmarkdown yaml tinytest

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

3direct

0indirect

Depends 1 · Imports 2

Suggested by 1

Depends, Imports or LinkingTo, most downloaded first

rqdatatable cdata WVPlots

Suggests, most downloaded first

vtreat

How these are counted

Code & Tests

People & History

People (2)

John Mount

Author, Maintainer since 0.2.0 (2018)

Win-Vector LLC

Copyright holder

Releases (37)

Pick two releases to compare their code metrics.

1.5.1Latest
record
2026-09-08 · current release · diff ↗
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.99
record
2023-08-20 · diff ↗
R
R 4.3.0 released · 2023-04-21
R
R 4.2.0 released · 2022-04-22
1.4.9
record
2022-02-28 · diff ↗
1.4.8
record
2022-01-22 · diff ↗
1.4.7
record
2021-06-10 · diff ↗
R
R 4.1.0 released · 2021-05-18
1.4.6
record
2020-10-17 · diff ↗ ·
removed 1 export
run_rquery_tests
1.4.5
record
2020-08-12 · diff ↗ ·
added 1 export
rq_head
R
R 4.0.0 released · 2020-04-24
1.4.4
record
2020-02-18 · diff ↗
1.4.3
record
2020-02-01 · diff ↗ ·
removed 13 exports
%.>%, %:=%, apply_left, apply_right, build_frame, draw_frame, let, map_to_char, mk_tmp_name_source, qae, qc, qchar_frame, qe

added 1 export
make_assignments

Show 31 earlier eventsHide 31 earlier events

1.4.2
record
2020-01-19 · diff ↗
1.4.1
record
2020-01-09 · diff ↗
1.4.0
record
2019-12-01 · diff ↗
1.3.9
record
2019-10-27 · diff ↗ ·
removed 4 exports
add_relop, get_relop_list_stages, make_relop_list, materialize_relop_list_stages

added 3 exports
arrow, ex, wrap
1.3.8
record
2019-09-15 · diff ↗ ·
added 3 exports
convert_yaml_to_pipeline, order_rows, to_transport_representation
1.3.7
record
2019-07-29 · diff ↗
1.3.6
record
2019-07-04 · diff ↗
1.3.5
record
2019-06-26 · diff ↗
1.3.4
record
2019-06-14 · diff ↗ ·
added 1 export
rq_function_mappings
1.3.3
record
2019-06-02 · diff ↗
R
R 3.6.0 released · 2019-04-26
1.3.2
record
2019-03-10 · diff ↗
1.3.1
record
2019-02-14 · diff ↗ ·
added 1 export
run_rquery_tests
1.3.0
record
2019-01-29 · diff ↗ ·
added 14 exports
add_relop, get_relop_list_stages, make_relop_list, materialize_relop_list_stages, pre_sql_fn, pre_sql_identifier, pre_sql_string, pre_sql_sub_expr, pre_sql_to_query, pre_sql_token, row_counts, rquery_default_methods, setDBOpt, str_pre_sql_sub_expr
1.2.1
record
2018-12-16 · diff ↗ ·
added 7 exports
extend, order_expr, order_expr_nse, order_expr_se, project, select_rows, theta_join
1.2.0
record
2018-11-07 · diff ↗
1.1.1
record
2018-10-26 · diff ↗
1.1.0
record
2018-09-20 · diff ↗ ·
added 1 export
lookup_by_column
1.0.0
record
2018-09-10 · diff ↗ ·
added 1 export
rquery_default_db_info
0.6.2
record
2018-08-15 · diff ↗ ·
added 2 exports
aggregate_nse, aggregate_se
0.6.1
record
2018-08-01 · diff ↗ ·
removed 9 exports
%>>%, dbi_colnames, dbi_coltypes, dbi_connection_advice, dbi_connection_tests, dbi_copy_to, dbi_nrow, dbi_remove_table, dbi_table_exists

added 4 exports
affine_transform, quote_table_name, rlook, rstr
0.5.0
record
2018-06-18 · diff ↗ ·
removed 4 exports
dbi_connection_name, dbi_connection_preferences, dbi_execute, materialize_sql_statement

added 38 exports
%.>%, %:=%, %>>%, apply_left, apply_right, build_frame, complete_design, db_td, dbi_coltypes, dbi_connection_advice, draw_frame, example_employee_date, expand_grid, let, local_td, map_to_char, materialize_node, materialize_sql, mk_td, mk_tmp_name_source, qae, qc, qchar_frame, qe, quote_identifier, quote_literal, quote_string, rq_colnames, rq_coltypes, rq_connection_advice and 8 more
0.4.3
record
2018-05-08 · diff ↗ ·
removed 1 export
replace_null_cols

added 21 exports
actualize_join_plan, assign_slice, build_join_plan, dbi_execute, describe_tables, drop_columns, format_node, graph_join_plan, if_else_op, inspect_join_plan, key_inspector_all_cols, key_inspector_postgresql, key_inspector_sqlite, map_column_values, normalize_cols, null_replace, op_diagram, pick_top_k, set_indicator, topo_sort_tables, unionall
R
R 3.5.0 released · 2018-04-23
0.4.2
record
2018-04-05 · diff ↗ ·
added 7 exports
dbi_connection_name, dbi_connection_preferences, dbi_connection_tests, dbi_table_exists, getDBOption, materialize_sql_statement, setDBOption
0.4.1
record
2018-03-18 · diff ↗ ·
removed 1 export
materialize_node

added 6 exports
dbi_colnames, dbi_nrow, dbi_remove_table, quantile_cols, quantile_node, sql_expr_set
0.4.0
record
2018-03-10 · diff ↗ ·
removed 2 exports
execute_data_frame, to_pre_sql

added 9 exports
commencify, count_null_cols, execute, mark_null_cols, materialize_node, non_sql_node, replace_null_cols, rsummary, rsummary_node
0.3.1
record
2018-02-10 · diff ↗ ·
added 1 export
materialize
0.3.0
record
2018-01-31 · diff ↗
0.2.0
record
2018-01-24
R
R 3.4.0 released · 2017-04-21

Package metadata

First published: 2018-01-24
Total releases: 37 / 8 yrs
License: GPL-2 | GPL-3 OSI
Minimum R: ≥ 3.4.0
Download size: 491 KB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("rquery")

Format

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

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 rquery version 1.5.1 [Data set]. HJJB, LLC. Data release v2026-10-23. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-23, 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 →