Function removeRedundantSubqueries

packages/db/src/query/optimizer.ts:454–463

* Removes redundant subqueries that don't add value. * A subquery is redundant if it only wraps another query without adding * WHERE, SELECT, GROUP BY, HAVING, ORDER BY, or LIMIT/OFFSET clauses. * * @param query - The QueryIR to process * @returns A new QueryIR with redundant subqueries removed

(query: QueryIR)

 * @returns A new QueryIR with redundant subqueries removed
 */
function removeRedundantSubqueries(query: QueryIR): QueryIR {
  return {
    ...query,
    from: removeRedundantFromClause(query.from),
    join: query.join?.map((joinClause) => ({
      ...joinClause,
      from: removeRedundantJoinFromClause(joinClause.from),
    })),
  }
}

/**
 * Removes redundant subqueries from a FROM clause.