> The equivalent in a relational database would be writing a query without a where statement,
Sort of, though I'd say scan operations are typically more expensive in any RDMS.
The probably becomes when you want/need something more than the secondary index, then you gotta get more creative.
Caveat: I used to work at Amazon (not in AWS), but don't anymore.