Article analysis
Amazon RDS Data API response-size limits → constrains → Row-based pagination
Row pagination does not guarantee compliance with byte limits when an individual record contains large audit JSON; both the per-row and total-response limits must be considered.
Read the evidence
Ordinary row-based pagination can reduce the response size of many lists, but if a row contains very large audit JSON, even LIMIT 1 cannot guarantee that a single response is safe. AWS also separately describes a 64 KB per-row limit, so both individual rows and the total response should be considered.
Background sources for the article's reasoning: [S4] Amazon Web Services
Read the full research