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

9,524

Last month

1,478

Last week

392

Average per day

49

Daily downloads

Total downloads

Description file content

Package
rquery
Type
Package
Title
Relational Query Generator for Data Manipulation at Scale
Version
1.2.0
Date
2018-11-06
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.6.3), 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-11-07 03:32:21 UTC; johnmount
Author
John Mount [aut, cre], Win-Vector LLC [cph]
Repository
CRAN
Date/Publication
2018-11-07 05:40:06 UTC

install.packages('rquery')

1.2.0

a month ago

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

John Mount

GPL-3

Depends on

R (>= 3.4.0)

Imports

wrapr (>= 1.6.3), utils, stats

Suggests

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

Discussions