[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1638) Add ability to query parent record info from child table query without joins for the Salesforce Translator

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