Multi table queries; At the moment, the query is fired only on a single table, can each attribute be sourced from different tables to form one large query with joins etc?

akshaykatre / querybuilder

Apache License 2.0

0 stars 0 forks source link

Multi table queries; At the moment, the query is fired only on a single table, can each attribute be sourced from different tables to form one large query with joins etc? #2

Open quantsegu opened 4 years ago

quantsegu commented 4 years ago

What is your idea here?

To connect more than one table based on relationships?
Then we need to have a proper Primarykey and Foriegn Key Relations created but also a central place to manage this. or through the config file.

akshaykatre commented 4 years ago

The idea is that you can join tables with attributes that are sourced from different tables; Indeed then you will need to know the Primary and Foreign keys for the relations between tables.

This means the configuration file (which at the moment is an excel or a JSON) will have to be re-thought about;

Perhaps its ambitious for the moment and can be kept aside for future development.