I apologize in advance if this functinality is already avaialble or this idea is posted.
I am a business user and when I think about migrating to Common Data Service storing and using my business data, my first and foremost thought is: Can use SQL/query like features I would use in MS Access? I don't believe lookup relationship between entities can solve this problem. I need to be able to build queries similar to MS Access so that I can fetch data from two differnt tables and present on a dashboard (perhaps in mode-driven apps).
If this functionality does not exist, the idea i would like to post - Is it possible to add SQL, table relationships, queries and other features similar to MS Access to Common Data Service entities.