The YQL Social Tables provide access to the same Yahoo! social data that is available through the Yahoo! Social REST APIs.
The YQL Social Tables offer the following advantages over using the REST APIs:
The me variable stores the signed-in user's GUID, allowing you to access the data of the signed-in user without specifying the
user's GUID. For example, the YQL statement below returns the profile of the signed-in user:
SELECT * FROM social.profile WHERE guid=me
Ability to join data from different APIs using sub-selects or predefined tables that include joins, such as the social.contacts.updates table