This reference architecture shows how create a searchable, paginated list on domain aggregates from purpose-built databases with a step transformation and SQL queries. Apply the command query responsibility segregation (CQRS) pattern to an event-driven microservice architecture to enable searching, pagination, and sorting by querying eventually-consistent data projections in Amazon Aurora.