Common service in system design -- Friendship service

单向好友关系 双向好友关系。

so what kind of db should we choose?
SQL or NoSQL?

now we use NoSQL Cassandra to see how to store friendship table.