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.

Total

19,519

Last month

1,434

Last week

345

Average per day

48

Daily downloads

Total downloads

Description file content

Package
rquery
Type
Package
Title
Relational Query Generator for Data Manipulation at Scale
Version
1.3.7
Date
2019-07-29
Maintainer
John Mount
URL
BugReports
https://github.com/WinVector/rquery/issues
Description
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.
License
GPL-2 | GPL-3
Encoding
UTF-8
Depends
R (>= 3.4.0)
Imports
wrapr (>= 1.8.8), utils, stats, methods
Suggests
DBI, RSQLite, rqdatatable, igraph, DiagrammeR, knitr, rmarkdown, RUnit
LazyData
true
RoxygenNote
6.1.1
ByteCompile
true
VignetteBuilder
knitr
NeedsCompilation
no
Packaged
2019-07-29 16:43:02 UTC; johnmount
Author
John Mount [aut, cre], Win-Vector LLC [cph]
Repository
CRAN
Date/Publication
2019-07-29 17:10:02 UTC

install.packages('rquery')

1.3.7

25 days ago

https://github.com/WinVector/rquery/

John Mount

GPL-2 | GPL-3

Depends on

R (>= 3.4.0)

Imports

wrapr (>= 1.8.8), utils, stats, methods

Suggests

DBI, RSQLite, rqdatatable, igraph, DiagrammeR, knitr, rmarkdown, RUnit

Discussions