Skip to content

rquery

Relational Query Generator for Data Manipulation at Scale

v1.4.99 · Aug 19, 2023 · GPL-2 | GPL-3
CRAN GitHub Mirror

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.

Downloads

3.3K

Last 30 days

2106th

3.3K

Last 90 days

3.3K

Last year

CRAN Check Status

14 NOTE
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang NOTE
r-devel-linux-x86_64-debian-gcc NOTE
r-devel-linux-x86_64-fedora-clang NOTE
r-devel-linux-x86_64-fedora-gcc NOTE
r-devel-macos-arm64 NOTE
r-devel-windows-x86_64 NOTE
r-oldrel-macos-arm64 NOTE
r-oldrel-macos-x86_64 NOTE
r-oldrel-windows-x86_64 NOTE
r-patched-linux-x86_64 NOTE
r-release-linux-x86_64 NOTE
r-release-macos-arm64 NOTE
r-release-macos-x86_64 NOTE
r-release-windows-x86_64 NOTE
Check details (14 non-OK)
NOTE r-devel-linux-x86_64-debian-clang

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-devel-linux-x86_64-debian-gcc

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-devel-linux-x86_64-fedora-clang

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-devel-linux-x86_64-fedora-gcc

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-devel-macos-arm64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-devel-windows-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-oldrel-macos-arm64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-oldrel-macos-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-oldrel-windows-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-patched-linux-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-release-linux-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-release-macos-arm64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-release-macos-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^
NOTE r-release-windows-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                                                   ^

Check History

NOTE 0 OK · 14 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 9, 2026
NOTE r-devel-linux-x86_64-debian-clang

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-devel-linux-x86_64-debian-gcc

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-devel-linux-x86_64-fedora-clang

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-devel-linux-x86_64-fedora-gcc

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-devel-macos-arm64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-devel-windows-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-patched-linux-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-release-linux-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-release-macos-arm64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-release-macos-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-release-windows-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-oldrel-macos-arm64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-oldrel-macos-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to
NOTE r-oldrel-windows-x86_64

Rd files

checkRd: (-1) ex.Rd:20: Lost braces
    20 | Execute a ops-dag using `code{wrap()}` data as values.
       |                              ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to ensure {col} is a column name.}
       |                                          ^
checkRd: (-1) sql_node.Rd:29: Lost braces; missing escapes or markup?
    29 | \item{expand_braces}{logical if TRUE use {col} notation to

Reverse Dependencies (4)

depends

rqdatatable

imports

WVPlots cdata

suggests

vtreat

Dependency Network

Dependencies Reverse dependencies wrapr rqdatatable WVPlots cdata vtreat rquery

Version History

new 1.4.99 Mar 9, 2026