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]
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 15 Apr. 2025.
Previous versions and publish date:
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
03/1603/1703/1803/1903/2003/2103/2203/2303/2403/2503/2603/2703/2803/2903/3003/3104/0104/0204/0304/0404/0504/0604/0704/0804/0904/1004/1104/1204/1304/14Downloads for rquery405060708090100110120130140150160170TrendBars

Today's Hot Picks in Authors and Packages

mt  
Metabolomics Data Analysis Toolbox
Functions for metabolomics data analysis: data preprocessing, orthogonal signal correction, PCA ana ...
Download / Learn more Package Citations See dependency  
ktsolve  
Configurable Function for Solving Families of Nonlinear Equations
This is designed for use with an arbitrary set of equations with an arbitrary set of unknowns. The ...
Download / Learn more Package Citations See dependency  
StructFDR  
False Discovery Control Procedure Integrating the Prior Structure Information
Perform more powerful false discovery control (FDR) for microbiome data, taking into account the pri ...
Download / Learn more Package Citations See dependency  
quickcode  
Quick and Essential 'R' Tricks for Better Scripts
The NOT functions, 'R' tricks and a compilation of some simple quick plus often used 'R' codes to im ...
Download / Learn more Package Citations See dependency  
ffscrapr  
API Client for Fantasy Football League Platforms
Helps access various Fantasy Football APIs by handling authentication and rate-limiting, forming ap ...
Download / Learn more Package Citations See dependency  
Maintainer: Tan Ho (view profile)
bSims  
Agent-Based Bird Point Count Simulator
A highly scientific and utterly addictive bird point count simulator to test statistical assumptio ...
Download / Learn more Package Citations See dependency  

24,012

R Packages

207,311

Dependencies

64,993

Author Associations

24,013

Publication Badges

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