The Data Explorer is intelligent enough to understand relationships between exposed data interfaces and automatically create joins across tables, master lists and detailed drill-downs, tabbed interfaces, updateable grids for child data, and rich filtering and sorting capabilities.
More importantly, it can create those relationships in a Managed API, by defining your application in the Data Explorer interface itself.