Fix parsing subquery in select or where condition

[Kumac13]

Why

• Unable to parse subquery as shown below:

  SOQLGenerator >>> Account.select(Id, Name, (select Id, Name from Contact)).limit(10)
  Syntax error: the word before the query method must be a dot

What

• Need to determine the correct syntax for writing subqueries in this tool

[Kumac13]

About relationship queries in SOQL

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_query_using.htm

Query Child-to-Parent Relationships

• SOQL

  SELECT 
  Id, 
  Name,
  Account.Name
  FROM
  Contact 
  WHERE 
  Account.Industry = 'media'

• SQL

  SELECT 
  Id, 
  Name,
  Account.Name
  FROM
  Contact
  LEFT JOIN
  Account
  ON
  Contact.AccountId = Account.Id
  WHERE
  Account.Industry = 'media'

• SOQL Generator

  Contact.select(Id, Name, Account.Name).where(Account.Industry = 'media')

Query Parent-to-Child Relationships

• SOQL

  SELECT 
  Name,
  (
  SELECT 
    LastName
  FROM 
    Contacts
  WHERE 
    CreatedBy.Alias = 'x'
  ) 
  FROM 
  Account
  WHERE 
  Industry = 'media'

• SQL

  SELECT
  Name,
  Contact.LastName
  FROM 
  Account
  LEFT JOIN
  Contact
  ON
  Account.Id = Contact.AccountId
  WHERE 
  Industry = 'media'