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.1K

Last 30 days

2343rd

10.3K

Last 90 days

43.9K

Last year

Trend: -16% (30d vs prior 30d)

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 10, 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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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
...[truncated]...
  ^
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.}
       |                                                                   ^

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 10, 2026
updated 1.4.99 ← 1.4.9 diff Aug 19, 2023
updated 1.4.9 ← 1.4.8 diff Feb 27, 2022
updated 1.4.8 ← 1.4.7 diff Jan 21, 2022
updated 1.4.7 ← 1.4.6 diff Jun 9, 2021
updated 1.4.6 ← 1.4.5 diff Oct 16, 2020
updated 1.4.5 ← 1.4.4 diff Aug 11, 2020
updated 1.4.4 ← 1.4.3 diff Feb 17, 2020
updated 1.4.3 ← 1.4.2 diff Jan 31, 2020
updated 1.4.2 ← 1.4.1 diff Jan 18, 2020
updated 1.4.1 ← 1.4.0 diff Jan 8, 2020
updated 1.4.0 ← 1.3.9 diff Nov 30, 2019
updated 1.3.9 ← 1.3.8 diff Oct 26, 2019
updated 1.3.8 ← 1.3.7 diff Sep 14, 2019
updated 1.3.7 ← 1.3.6 diff Jul 28, 2019
updated 1.3.6 ← 1.3.5 diff Jul 3, 2019
updated 1.3.5 ← 1.3.4 diff Jun 25, 2019
updated 1.3.4 ← 1.3.3 diff Jun 13, 2019
updated 1.3.3 ← 1.3.2 diff Jun 1, 2019
updated 1.3.2 ← 1.3.1 diff Mar 9, 2019