Almost every single host SQL solution I know of is built on a B-Tree for at least some of its properties. A B-Tree is nothing more than a lexicographically sorted key-value store.
Consus is a lexicographically sorted key-value store.
Where you will hit performance bottlenecks is when your query planner/executer makes traditional assumptions about performance that do not hold across machines.
A good SQL implementation on top of a kvs should not force you to accommodate it any more than your current "normal" databases subconsciously train you to accommodate your disks (hint: they do).
I would be very surprised if anyone is still running their primary data store on "disks" that cares about performance. BTW, look at the design of F1 and you will see that they do object like hierarchical storage of related tables to ensure that they don't have to go cross partition for queries.
Consus is a lexicographically sorted key-value store.
Where you will hit performance bottlenecks is when your query planner/executer makes traditional assumptions about performance that do not hold across machines.
A good SQL implementation on top of a kvs should not force you to accommodate it any more than your current "normal" databases subconsciously train you to accommodate your disks (hint: they do).