The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.
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 |
Reference manual: | rquery.pdf |
Vignettes: |
Assignment Partitioner Parameterized rquery Pipeable SQL Query Generation R mapping rquery Introduction rquery Many Columns SQL quoting |
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 depends: | rqdatatable |
Reverse imports: | cdata, WVPlots |
Reverse suggests: | vtreat |
Please use the canonical form https://CRAN.R-project.org/package=rquery to link to this page.
These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.