Is there an implementation of the Salesforce Query?

Cloud Elements offers the endpoint GET /query for the Salesforce Sales Cloud (SFDC) element only. Note that this endpoint is non-standard so it is not available in the Swagger / API Docs, but it is available on the element. Here is an example:

/hubs/crm/query?q%3Dselect%20*%20from%20opportunity

The SFDC element also supports a raw query endpoint (GET /raw-query) that can be used when nested select statements are required. Just as with /query this endpoint is not in the API Docs, but is accessible when you make API calls against SFDC element instances. An example of using this endpoint is:

/hubs/crm/raw-query?q=select%20id%20from%20Account%20where%20OwnerId%20in%20(select%20User.Id%20from%20User%20where%20User.Id%20=%20'005f4111002Nmt1XXX')