How to query all files attached to the Opportunity

Solved. The file is actually a content document and could be easily obtained via foreign key:

SELECT ContentDocumentId FROM ContentDocumentLink WHERE LinkedEntityId = '<Opportunity or other object id here>'