Entity Manager is a platform-specific tool that interprets database schemas in a unique and opinionated way. This tool is particularly beneficial for NoSQL databases like DynamoDB, where schema and query abstractions are not readily available. The process involves creating a single-table design to efficiently query data, focusing on composite primary keys for data entities. Secondary indexes are also essential for supporting various query scenarios, such as finding records based on creation date or user information. The tool’s approach is highly opinionated, requiring careful consideration of the table structure to support efficient data retrieval.
https://karmanivero.us/projects/entity-manager/evolving-a-nosql-db-schema/