Databases that use SQL but are usage based like DynamoDB?

Looking for a database that uses SQL/ postgres extensions as its interface and has a usage based model like DynamoDB. I quite like DynamoDB since it frees me up from thinking about instance types, memory requirements or whatever.