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.
precompute_table_join_paths(conn, input_table = NULL, relevant_tables = NULL)A list of join paths for each table in the database.
The connection object or database connection string.
The table from which the join path is computed.
A vector of tables that are relevant to the query.