CCNA, CCNP, MCSA, CCNA Final Exam, All Answer Test Module With 100/100

I have several questions? How can i query the node by its property? I see only to query by node id. And how can I get, for example all friends and unconfirmed friends of the node? At the moment I can do that only by querying the all relationships of the node, and iterate over it by checking the property of each relationship. My idea as the following: a node has parameter - id (userID), relationship has properties - directions - FROM_ME or TO_ME, status - CONFIRMED, UNCONFIRMED. All the quries are performed in REST API in Java. How can I do that in the simple way like in SQL, f.e., SELECT friends WHERE friend_id = 1? References to some tutorials with the solutions and techniques of such questions qould be appreciated