AFAIK theoretically any database can be built on top of a key value store, and any transactional database on top of a key value store that also has transactions.
TiDB is an example of a distributed SQL on top of a transactional key value store called TiKV.
TiDB is an example of a distributed SQL on top of a transactional key value store called TiKV.