I use DynamoDB for most production workloads. With that said, I really miss the ability to run ad-hoc queries against a relational database.

Joins can be baked in to DynamoDB for application access patterns - but frequently I (or product/sales) want to know "how many people with X also have Y", which is really hard to do with DynamoDB.