rquery: Relational Query Generator for Data Manipulation at Scale

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.

Version: 1.4.99
Depends: R (≥ 3.4.0), wrapr (≥ 2.0.9)
Imports: utils, stats, methods
Suggests: DBI, RSQLite, rqdatatable (≥ 1.3.2), igraph, knitr, rmarkdown, yaml, tinytest
Published: 2023-08-20
DOI: 10.32614/CRAN.package.rquery
Author: John Mount [aut, cre], Win-Vector LLC [cph]
Maintainer: John Mount <jmount at win-vector.com>
BugReports: https://github.com/WinVector/rquery/issues
License: GPL-2 | GPL-3
URL: https://github.com/WinVector/rquery/, https://winvector.github.io/rquery/
NeedsCompilation: no
Materials: README NEWS
CRAN checks: rquery results

Documentation:

Reference manual: rquery.pdf
Vignettes: Assignment Partitioner
Parameterized rquery
Pipeable SQL
Query Generation
R mapping
rquery Introduction
rquery Many Columns
SQL quoting

Downloads:

Package source: rquery_1.4.99.tar.gz
Windows binaries: r-devel: rquery_1.4.99.zip, r-release: rquery_1.4.99.zip, r-oldrel: rquery_1.4.99.zip
macOS binaries: r-release (arm64): rquery_1.4.99.tgz, r-oldrel (arm64): rquery_1.4.99.tgz, r-release (x86_64): rquery_1.4.99.tgz, r-oldrel (x86_64): rquery_1.4.99.tgz
Old sources: rquery archive

Reverse dependencies:

Reverse depends: rqdatatable
Reverse imports: cdata, WVPlots
Reverse suggests: vtreat

Linking:

Please use the canonical form https://CRAN.R-project.org/package=rquery to link to this page.