Salamander
Member
When dragging two tables into the query builder that do not have a foreign key constraint between them, have a button that perform a BFS search on the constraints starting from both tables. If a "path" between the two tables is found within N (default 4?) hops, offer a way to load those tables directly into the query builder window.
So, from a user's point of view, I drag the "Company" and the "User" table into the query builder, and click the "connect path" icon. After a few seconds, I get the Company-Company_Department-Department_User_MM-User query and tables loaded into my query builder auto-magically.
Might require local caching of foreign key constraints to be fast.
So, from a user's point of view, I drag the "Company" and the "User" table into the query builder, and click the "connect path" icon. After a few seconds, I get the Company-Company_Department-Department_User_MM-User query and tables loaded into my query builder auto-magically.
Might require local caching of foreign key constraints to be fast.