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 modeling step, explicit query reasoning and checking.

Total

2,933

Last month

338

Last week

89

Average per day

11

Daily downloads

Total downloads

Description file content

Package
rquery
Type
Package
Title
Relational Query Generator for Data Manipulation at Scale
Version
0.6.1
Date
2018-08-01
Maintainer
John Mount
URL
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 modeling step, explicit query reasoning and checking.
License
GPL-3
Encoding
UTF-8
Depends
R (>= 3.4.0)
Imports
wrapr (>= 1.5.0), utils, stats
Suggests
DBI, RSQLite, igraph, DiagrammeR, DiagrammeRsvg, rsvg, knitr, rmarkdown, testthat
LazyData
true
RoxygenNote
6.1.0
ByteCompile
true
VignetteBuilder
knitr
NeedsCompilation
no
Packaged
2018-08-01 17:31:52 UTC; johnmount
Author
John Mount [aut, cre], Win-Vector LLC [cph]
Repository
CRAN
Date/Publication
2018-08-01 17:50:03 UTC

install.packages('rquery')

0.6.1

12 days ago

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

John Mount

GPL-3

Depends on

R (>= 3.4.0)

Imports

wrapr (>= 1.5.0), utils, stats

Suggests

DBI, RSQLite, igraph, DiagrammeR, DiagrammeRsvg, rsvg, knitr, rmarkdown, testthat

Discussions