Running into a major limitation in Zoho Analytics:
correlated subqueries simply don’t work, even in completely standard SQL patterns inside a JOIN.

Example:

LEFT JOIN "Bills" b
  ON d."Id" = b."Deal ID"
 AND EXISTS (
       SELECT 1
       FROM "Bill Item" bi
      WHERE bi."Bill ID" = b."Bill ID"
        AND bi."Product ID" IN (...)
        AND d."Some Field" = 'X'   -- breaks
     )

Zoho throws:

Unknown table or alias 'd' used in select query.

Every normal SQL engine supports this. This is not exotic syntax — it’s basic correlated-subquery logic used everywhere for filtering child records, running totals, conditional joins, etc.

Because this simple pattern isn’t allowed, I had to:

• Build a separate helper query table

• Move logic out of the JOIN

• Maintain extra objects just to replicate what SQL usually does in a single query

This creates unnecessary complexity and overhead.

I've seen a few posts where Zoho mentions that this is on their to-do list...those posts are from 5+ years ago and no fix...Is there any plan for Zoho Analytics to support correlated subqueries at all? It would eliminate a ton of workarounds and make complex reporting far more manageable.