The following SOQL queries are not supported for the guess schema and guess query features of tSalesforceInput:
the SOQL query using the aggregate function
the SOQL query using the TYPEOF expression
the SOQL query using alias
the prefix in the SOQL query is the same as the module name after FROM
SELECT Account.Name, (SELECT Contact.LastName FROM Account.Contacts) FROM Accountis not supported, while
SELECT Name, (SELECT LastName FROM Contacts) FROM Accountthat performs the same function is supported.
the SOQL query with multiple modules after FROM
SELECT Contact.Firstname, Account.Name FROM Contact,Contact.Accountis not supported. However, the child-to-parent and parent-to-child relationship queries are supported, so this query can be improved to
SELECT Firstname, Account.Name FROM Contact.
the SOQL query using toLabel()
the field with the underscore character '_' in its name
Besides, the underscore character '_' in any custom field name needs to be manually replaced with the dot character '.' in the generated SOQL query.