Add ability to query parent record info from child table query without joins for the Salesforce Translator ---------------------------------------------------------------------------------------------------------- Key: TEIID-1638 URL: https://issues.jboss.org/browse/TEIID-1638 Project: Teiid Issue Type: Feature Request Components: Salesforce Connector Affects Versions: 7.1.1 Reporter: Debbie Steigner Labels: eds, salesforce Salesforce.com SOQL supports selecting parent record value through reference key name. We need to query parent record info from child table query. For example, if I have column parentid in Contact object which is reference key to account object, I can do in SOQL in salesforce.com something like this. Select c.Id, c.Name, c.AccountId, c.Account.Name from Contact c But if i want to do the same in EDS, I have to use Relationship Queries (join of two tables Account and Contact) which is huge impact on performance