The current way of adding new entities to a query could be substantially improved if the option to visualize an entity diagram would be presented:
- Showing all entities and relations (similar to current Entities Diagram)
- Highlighting which entities and foreign keys used on joins are already being used in the query.
- Allowing to drag from and drop entities onto the query.
This view should be presented in a modal window.
For simple queries this would be a must, although it is on advanced queries where this one would REALLY be helpful.