Closed d416 closed 1 year ago
Thanks @d416 for raising the issue. Apologies for the radio silence!!!
While the idea of using SOQL relationship queries holds promise, we currently lack a well-defined structural blueprint for the table's composition and the specific data it will yield.
We regret to inform you that we are not considering the addition of this feature at this time. However, we will revisit the idea as soon as we have a solid grasp of the table design 👍.
Is your feature request related to a problem? Please describe. Feature request: Support for Salesoforce SOQL relationship queries.
Describe the solution you'd like Relationship between object can be maintained in Salesforce through 'lookup' fields. For example, on the Contact object there is a field called AccountId which will return the ID of the Account its associated with, however if you wanted to also retrieve the Name field on the Account, you could query it directly through the Contact schema via 'dot' notation like so: Select Id, Name, AccountId, Account.Name from Contact limit 100
Describe alternatives you've considered The alternative is to download all Contact records, download all Account records, then join them to get Name
Additional context Salesforce docs on relationship queries https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships.htm
Alternative idea: Allow direct SOQL passthrough of queries, then just parse the schema that is returned?