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 18 Sep. 2026.
Previous versions and publish date:
(2026-09-08 19:00), 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), 1.4.99 (2023-08-20 04:40)
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

data360r  
Wrapper for 'TCdata360' and 'Govdata360' API
Makes it easy to engage with the Application Program Interface (API) of the 'TCdata360' and 'Govdat ...
Download / Learn more Package Citations See dependency  
hmeasure  
The H-Measure and Other Scalar Classification Performance Metrics
Classification performance metrics that are derived from the ROC curve of a classifier. The package ...
Download / Learn more Package Citations See dependency  
downlit  
Syntax Highlighting and Automatic Linking
Syntax highlighting of R code, specifically designed for the needs of 'RMarkdown' packages like 'pk ...
Download / Learn more Package Citations See dependency  
eyelinker  
Import ASC Files from EyeLink Eye Trackers
Imports plain-text ASC data files from EyeLink eye trackers into (relatively) tidy data frames for ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
injectoR  
R Dependency Injection
R dependency injection framework. Dependency injection allows a program design to follow the depend ...
Download / Learn more Package Citations See dependency  

28,565

R Packages

239,283

Dependencies

75,677

Author Associations

28,566

Publication Badges

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