Man pages for rquery
Relational Query Generator for Data Manipulation at Scale
| actualize_join_plan | Execute an ordered sequence of left joins. |
| affine_transform | Implement an affine transformaton |
| apply_right.relop | Execute pipeline treating pipe_left_arg as local data to be... |
| apply_right_S4-ANY-rquery_db_info-method | Apply pipeline to a database. |
| apply_right_S4-data.frame-relop_arrow-method | S4 dispatch method for apply_right. |
| apply_right_S4-relop_arrow-relop_arrow-method | S4 dispatch method for apply_right. |
| arrow | Data arrow |
| assign_slice | Assign a value to a slice of data (set of rows meeting a... |
| build_join_plan | Build a join plan. |
| column_names | Return column names |
| columns_used | Return columns used |
| commencify | Hyderdrive (science fiction show) synonym for 'execute' |
| complete_design | Complete an experimental design. |
| convert_yaml_to_pipeline | Convert a series of simple objects (from YAML deserializaton)... |
| count_null_cols | Count NULLs per row for given column set. |
| db_td | Construct a table description from a database source. |
| describe_tables | Build a nice description of a table. |
| drop_columns | Make a drop columns node (not a relational operation). |
| ex | Execute a wrapped execution pipeline. |
| example_employee_date | Build some example tables (requires DBI). |
| execute | Execute an operator tree, bringing back the result to memory. |
| expand_grid | Cross product vectors in database. |
| extend | Extend data by adding more columns. |
| extend_se | Extend data by adding more columns. |
| format_node | Format a single node for printing. |
| getDBOption | Get a database connection option. |
| graph_join_plan | Build a draw-able specification of the join diagram |
| if_else_block | Build a sequence of statements simulating an if/else... |
| if_else_op | Build a 'relop' node simulating a per-row... |
| inspect_join_plan | check that a join plan is consistent with table descriptions. |
| key_inspector_all_cols | Return all columns as guess of preferred primary keys. |
| key_inspector_postgresql | Return all primary key columns as guess at preferred primary... |
| key_inspector_sqlite | Return all primary key columns as guess at preferred primary... |
| local_td | Construct a table description of a local data.frame. |
| lookup_by_column | Use one column to pick values from other columns. |
| make_assignments | Make a list of assignments, applying many functions to many... |
| map_column_values | Remap values in a set of columns. |
| mark_null_cols | Indicate NULLs per row for given column set. |
| materialize | Materialize an optree as a table. |
| materialize_node | Create a materialize node. |
| materialize_sql | Materialize a user supplied SQL statement as a table. |
| mk_td | Make a table description directly. |
| natural_join | Make a natural_join node. |
| non_sql_node | Wrap a non-SQL node. |
| normalize_cols | Build an optree pipeline that normalizes a set of columns so... |
| null_replace | Create a null_replace node. |
| op_diagram | Build a diagram of a optree pipeline. |
| orderby | Make an orderby node (not a relational operation). |
| order_expr | Make a order_expr node. |
| order_expr_se | Make a order_expr node. |
| order_rows | Make an orderby node (not a relational operation). |
| pick_top_k | Build an optree pipeline that selects up to the top k rows... |
| pre_sql_fn | pre_sql_token funtion name |
| pre_sql_identifier | pre_sql_identifier: abstract name of a column and where it is... |
| pre_sql_string | pre_sql_string |
| pre_sql_sub_expr | pre_sql_sub_expr |
| pre_sql_token | pre_sql_token |
| pre_sql_to_query | Return SQL transform of tokens. |
| pre_sql_to_query.pre_sql_sub_expr | Convert a pre_sql token object to SQL query text. |
| pre_sql_to_query.pre_sql_token | Convert a pre_sql token object to SQL query text. |
| project | project data by grouping, and adding aggregate columns. |
| project_se | project data by grouping, and adding aggregate columns. |
| quantile_cols | Compute quantiles of specified columns (without... |
| quantile_node | Compute quantiles over non-NULL values (without... |
| quote_identifier | Quote an identifier. |
| quote_literal | Quote a value |
| quote_string | Quote a string |
| quote_table_name | Quote a table name. |
| rename_columns | Make a rename columns node (copies columns not renamed). |
| row_counts | Build an optree pipeline counts rows. |
| rq_colnames | List table column names. |
| rq_coltypes | Get column types by example values as a data.frame. |
| rq_connection_advice | Get advice for a DB connection (beyond tests). |
| rq_connection_name | Build a canonical name for a db connection class. |
| rq_connection_tests | Try and test database for some option settings. |
| rq_copy_to | Copy local R table to remote data handle. |
| rq_execute | Execute a query, typically an update that is not supposed to... |
| rq_function_mappings | Return function mappings for a connection |
| rq_get_query | Execute a get query, typically a non-update that is supposed... |
| rq_head | Get head of db table |
| rq_nrow | Count rows and return as numeric |
| rq_remove_table | Remove table |
| rq_table_exists | Check if a table exists. |
| rquery_apply_to_data_frame | Execute optree in an environment where d is the only data. |
| rquery_db_info | Build a db information stand-in |
| rquery_default_db_info | An example 'rquery_db_info' object useful for formatting... |
| rquery_default_methods | Default to_sql method implementations. |
| rquery-package | 'rquery': Relational Query Generator for Data Manipulation |
| rstr | Quick look at remote data |
| rsummary | Compute usable summary of columns of remote table. |
| rsummary_node | Create an rsumary relop operator node. |
| select_columns | Make a select columns node (not a relational operation). |
| select_rows | Make a select rows node. |
| select_rows_se | Make a select rows node. |
| setDBOpt | Set a database connection option. |
| setDBOption | Set a database connection option. |
| set_indicator | Make a set indicator node. |
| sql_expr_set | Build a query that applies a SQL expression to a set of... |
| sql_node | Make a general SQL node. |
| str_pre_sql_sub_expr | Structure of a pre_sql_sub_expr |
| tables_used | Return vector of table names used. |
| theta_join | Make a theta_join node. |
| theta_join_se | Make a theta_join node. |
| tokenize_for_SQL | Cross-parse from an R parse tree into SQL. |
| topo_sort_tables | Topologically sort join plan so values are available before... |
| to_sql | Return SQL implementation of operation tree. |
| to_transport_representation | Convert an rquery op diagram to a simple representation,... |
| unionall | Make an unionall node (not a relational operation). |
| wrap | Wrap a data frame for later execution. |
