The table storage entities are nice, but need more power. This should support secondary indexes (when those are added) and also partitions with mixed schema rows.
This goes along with full text search, the ability to reduce entity sets based on a textual LINQ query server side would speed up apps and reduce costs for customers.
Now that I've seen the way CouchDB implements Map and Reduce functions, I would prefer having the ability to create those functions within Table Storage over what I was thinking when I posed this suggestion.
Mike Kelly commented
Would also be nice to support the OrderBy LINQ clause when returning rows.
Because partitions are within a single table and each table can have heterogeneous rows, it should be possible to simulate one-to-many and even many-to-many relationships between rows of a single table. I'm looking for an easy way to set that up.
Transactions are also limited to a single partition within a single table, so I'm also hoping that there would be support for creating master and detail rows within a table/partition and update them all within a transaction.