Other packages > Find by keyword >

rquery  

Relational Query Generator for Data Manipulation at Scale
View on CRAN: Click here


Download and install rquery package within the R console
Install from CRAN:
install.packages("rquery")

Install from Github:
library("remotes")
install_github("cran/rquery")

Install by package version:
library("remotes")
install_version("rquery", "1.4.99")



Attach the package and use:
library("rquery")
Maintained by
John Mount
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2018-01-24
Latest Update: 2023-08-20
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.
How to cite:
John Mount (2018). rquery: Relational Query Generator for Data Manipulation at Scale. R package version 1.4.99, https://cran.r-project.org/web/packages/rquery. Accessed 16 Jul. 2026.
Previous versions and publish date:
(2026-07-09 06:53), 0.2.0 (2018-01-24 11:07), 0.3.0 (2018-01-31 18:40), 0.3.1 (2018-02-10 20:39), 0.4.0 (2018-03-10 20:24), 0.4.1 (2018-03-18 05:37), 0.4.2 (2018-04-05 21:15), 0.4.3 (2018-05-08 05:51), 0.5.0 (2018-06-18 23:50), 0.6.1 (2018-08-01 19:50), 0.6.2 (2018-08-15 07:10), 1.0.0 (2018-09-10 18:40), 1.1.0 (2018-09-20 21:50), 1.1.1 (2018-10-26 20:00), 1.2.0 (2018-11-07 06:40), 1.2.1 (2018-12-16 21:10), 1.3.0 (2019-01-29 10:30), 1.3.1 (2019-02-14 21:42), 1.3.2 (2019-03-10 18:00), 1.3.3 (2019-06-02 07:20), 1.3.4 (2019-06-14 21:02), 1.3.5 (2019-06-26 12:30), 1.3.6 (2019-07-04 19:20), 1.3.7 (2019-07-29 19:10), 1.3.8 (2019-09-15 18:40), 1.3.9 (2019-10-27 06:50), 1.4.0 (2019-12-01 21:10), 1.4.1 (2020-01-09 00:00), 1.4.2 (2020-01-19 19:50), 1.4.3 (2020-02-01 10:20), 1.4.4 (2020-02-18 17:50), 1.4.5 (2020-08-12 12:00), 1.4.6 (2020-10-17 19:40), 1.4.7 (2021-06-10 18:20), 1.4.8 (2022-01-22 19:32), 1.4.9 (2022-02-28 19:00)
Other packages that cited rquery R package
View rquery citation profile
Other R packages that rquery depends, imports, suggests or enhances
Complete documentation for rquery
Functions, R codes and Examples using the rquery R package
Some associated functions: actualize_join_plan . affine_transform . apply_right.relop . apply_right_S4-ANY-rquery_db_info-method . apply_right_S4-data.frame-relop_arrow-method . apply_right_S4-relop_arrow-relop_arrow-method . arrow . assign_slice . build_join_plan . column_names . columns_used . commencify . complete_design . convert_yaml_to_pipeline . count_null_cols . db_td . describe_tables . drop_columns . ex . example_employee_date . execute . expand_grid . extend . extend_se . format_node . getDBOption . graph_join_plan . if_else_block . if_else_op . inspect_join_plan . key_inspector_all_cols . key_inspector_postgresql . key_inspector_sqlite . local_td . lookup_by_column . make_assignments . map_column_values . mark_null_cols . materialize . materialize_node . materialize_sql . mk_td . natural_join . non_sql_node . normalize_cols . null_replace . op_diagram . order_expr . order_expr_se . order_rows . orderby . pick_top_k . pre_sql_fn . pre_sql_identifier . pre_sql_string . pre_sql_sub_expr . pre_sql_to_query . pre_sql_to_query.pre_sql_sub_expr . pre_sql_to_query.pre_sql_token . pre_sql_token . project . project_se . quantile_cols . quantile_node . quote_identifier . quote_literal . quote_string . quote_table_name . rename_columns . row_counts . rq_colnames . rq_coltypes . rq_connection_advice . rq_connection_name . rq_connection_tests . rq_copy_to . rq_execute . rq_function_mappings . rq_get_query . rq_head . rq_nrow . rq_remove_table . rq_table_exists . rquery-package . rquery_apply_to_data_frame . rquery_db_info . rquery_default_db_info . rquery_default_methods . rstr . rsummary . rsummary_node . select_columns . select_rows . select_rows_se . setDBOpt . setDBOption . set_indicator . sql_expr_set . sql_node . str_pre_sql_sub_expr . tables_used . theta_join . theta_join_se . to_sql . to_transport_representation . tokenize_for_SQL . topo_sort_tables . unionall . wrap . 
Some associated R codes: affine_transform.R . arrow.R . assign_slice.R . compare_frames.R . complete_design.R . db_def_methods_default.R . db_info.R . db_ops.R . drop_columns.R . ex_data_frame.R . extend.R . if_else_block.R . join_controller.R . lapply_bquote.R . lookup_by_column.R . make_assignments.R . map_cols.R . materialize.R . materialize_node.R . natural_join.R . non_sql_node.R . normalize.R . null_replace.R . op_diagram.R . order_by.R . order_expr.R . ordered_select_rows.R . package.R . partition_assignments.R . pre_sql.R . project.R . quantile.R . relop.R . rename.R . rlook.R . row_counts.R . rsummary.R . select_columns.R . select_rows.R . set_indicator.R . sql_expr_set.R . sql_node.R . table_source.R . theta_join.R . tokenize_for_sql.R . union_all.R . utils.R . work_with_NULLs.R . wrap_ex.R . yaml.R . zzz.R .  Full rquery package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

bbdetection  
Identification of Bull and Bear States of the Market
Implements two algorithms of detecting Bull and Bear markets in stock prices: the algorithm of Pagan ...
Download / Learn more Package Citations See dependency  
tarchetypes  
Archetypes for Targets
Function-oriented Make-like declarative pipelines for Statistics and data science are supported in t ...
Download / Learn more Package Citations See dependency  
schoolmath  
Functions and Datasets for Math Used in School
Contains functions and datasets for math taught in school. A main focus is set to prime-calculation. ...
Download / Learn more Package Citations See dependency  
stevedata  
Steve's Toy Data for Teaching About a Variety of Methodological, Social, and Political Topics
This is a collection of various kinds of data with broad uses for teaching. My students, and academ ...
Download / Learn more Package Citations See dependency  
Rnmr1D  
Perform the Complete Processing of a Set of Proton Nuclear Magnetic Resonance Spectra
Perform the complete processing of a set of proton nuclear magnetic resonance spectra from the free ...
Download / Learn more Package Citations See dependency  
wordnet  
WordNet Interface
An interface to WordNet using the Jawbone Java API to WordNet. WordNet (< ...
Download / Learn more Package Citations See dependency  

27,806

R Packages

239,283

Dependencies

73,837

Author Associations

27,807

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA