precompute_table_join_paths {acdcquery}

Precompute Table Join Paths

Description

This function precomputes join paths for all tables in a given database using a combination of forward and backward joins. It generates a list of data frames representing the join paths for each table, including information about tables to join, walk approaches (forward or backward), and common variables used for joining.

Usage

precompute_table_join_paths(conn, input_table = NULL, relevant_tables = NULL)

Arguments

conn

The connection object or database connection string.

input_table

The table from which the join path is computed.

relevant_tables

A vector of tables that are relevant to the query.

Value

A list of join paths for each table in the database.