Automatically adding Joins using Primary/Foreign keys within Data Sources

Would it be possible within the automatic schema generation to create joins as well using the Primary/Foreign keys within SQL DB's? This would enable developers to quickly engage with their data without having to define the joins when they should already be defined at a db schema level.

This could also be expanded to include a range of 'default' optional pre-aggregations on data, e.g. automatically inserting a pre-aggregation on data types such as boolean creates a count, within the same process.