Function generateVisualQuerySQL

src/utils/visualQuery.ts:320–344

(
  nodes: QueryNode[],
  edges: QueryEdge[],
  whereConditions: WhereCondition[],
  orderBy: OrderByClause[],
  groupBy: string[],
  limit: string,
  driver?: string | null,
)

 * Generates complete SQL query from visual query state
 */
export function generateVisualQuerySQL(
  nodes: QueryNode[],
  edges: QueryEdge[],
  whereConditions: WhereCondition[],
  orderBy: OrderByClause[],
  groupBy: string[],
  limit: string,
  driver?: string | null,
): string {
  if (nodes.length === 0) return '';

  const aliases = collectTableAliases(nodes);
  const { columns, hasAggregation, nonAggregatedCols } = collectSelectedColumns(nodes, aliases);

  let sql = 'SELECT\n';
  sql += generateSelectClause(columns);
  sql += generateFromClause(nodes, edges, aliases);
  sql += generateWhereClause(whereConditions);
  sql += generateGroupByClause(hasAggregation, nonAggregatedCols, groupBy);
  sql += generateHavingClause(whereConditions);
  sql += generateOrderByClause(orderBy, driver);
  sql += generateLimitClause(limit);

  return sql;
}