I'm not intimately familiar with either side, but I see it as:
- Costco buys x amount of product at y price from seller and then sells it in its store.
- Amazon provides a platform for sellers to sell with a cut going back to Amazon.
There is a fundamental difference between being a retailer and providing a retail platform.
All Costco would really have access to is how much they've bought and how that has performed for them. Meanwhile Amazon is providing a platform for companies with a policy that they will only use their data to help them, which is what is allegedly not happening.
I don't think anyone is going to argue with making complicated things simple. But from my experience, if it's complicated in SQL it's going to be a nightmare in the ORM. Generally, complicated SQL means that the underlying data was not modeled to solve the use case. Exactly as you mentioned, trying to simplify things in the ORM layer will be on a use case by use case level.
> And I don’t think the consumers of the GraphQL API should think about efficiency. They should just specify what data they need and then the backend is responsible for figuring out how to query the data model efficiently.
That is the point of the SQL language. It's declarative. You define what you want your data to look like and the query planner handles the actual fetching of the information in the most efficient way it can. Obviously it's not perfect and you still have to have someone who knows what they're doing to define schemas that make sense and indexes where appropriate, but that is a separate job from defining what data is needed.
No, I don't think it is. Early itunes was a media player and music store I could use to catalog my own music as well as license theirs. Spotify is a streaming music service with a free ads based model or paid monthly subscription to get access to most commercially released music. How is that anything like Pitch vs PowerPoint templates?
There is a fundamental difference between being a retailer and providing a retail platform.
All Costco would really have access to is how much they've bought and how that has performed for them. Meanwhile Amazon is providing a platform for companies with a policy that they will only use their data to help them, which is what is allegedly not happening.