A gaming company is looking to store comprehensive information about all the games they have released. Each game has unique attributes such as a name, version number, and category (e.g., sports, puzzles, strategy, etc.). Additionally, the games may have various other properties related to supported platforms and technical specifications, which can vary widely among different games.

You have been hired as an AWS Certified Developer Associate to develop a solution that fulfills the following use cases:

1. Retrieve all details about a game based on a specific name and version number.
2. Retrieve all details about all versions of a game given its name.
3. Retrieve all details about all games belonging to a specific category.

What solution would you recommend as the most efficient to meet these requirements?