rquery

Relational Query Generator for Data Manipulation at Scale

A 'SQL' query generator based on Edgar F. Codd's relational algebra and 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` and databases. 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 modeling step, and convenience methods for applying query trees to in-memory 'data.frame's.

Total

1,986

Last month

842

Last week

91

Average per day

28

Daily downloads

Total downloads

Description file content

Package
rquery
Type
Package
Title
Relational Query Generator for Data Manipulation at Scale
Version
0.4.3
Date
2018-05-07
Maintainer
John Mount
URL
Description
A 'SQL' query generator based on Edgar F. Codd's relational algebra and 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` and databases. 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 modeling step, and convenience methods for applying query trees to in-memory 'data.frame's.
License
GPL-3
Encoding
UTF-8
Depends
R (>= 3.4.0), wrapr (>= 1.3.0)
Imports
DBI, utils
Suggests
RSQLite, igraph, DiagrammeR, knitr, rmarkdown, testthat
LazyData
true
RoxygenNote
6.0.1
ByteCompile
true
VignetteBuilder
knitr
NeedsCompilation
no
Packaged
2018-05-08 02:10:00 UTC; johnmount
Author
John Mount [aut, cre], Win-Vector LLC [cph]
Repository
CRAN
Date/Publication
2018-05-08 03:51:56 UTC

install.packages('rquery')

0.4.3

12 days ago

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

John Mount

GPL-3

Depends on

R (>= 3.4.0), wrapr (>= 1.3.0)

Imports

DBI, utils

Suggests

RSQLite, igraph, DiagrammeR, knitr, rmarkdown, testthat

Discussions