DynamoDB how to perform Group by, joins in table


I am trying to start a project with server less & dynamodb, but I think we would need to support group by, aggregation , joins on multiple tables to build some APIs. I couldn’t find any information as to how this can be achieved. Are there any workarounds ? Or can anyone point me in the direction of the best alternative solution

DynamoDB is a super fast key/value store. It doesn’t support joins, group by or aggregation. Even conditions work different than you expect if you’re coming from a SQL background.