Function splitAndClauses

packages/db/src/query/optimizer.ts:547–558

* Step 1: Split all AND clauses recursively into separate WHERE clauses. * * This enables more granular optimization by treating each condition independently. * OR clauses are preserved as they cannot be split without changing query semantics. * * @param whereClauses - Array of WHERE expression

(
  whereClauses: Array<Where>,
)

 * ```
 */
function splitAndClauses(
  whereClauses: Array<Where>,
): Array<BasicExpression<boolean>> {
  const result: Array<BasicExpression<boolean>> = []

  for (const whereClause of whereClauses) {
    const clause = getWhereExpression(whereClause)
    result.push(...splitAndClausesRecursive(clause))
  }

  return result
}

// Helper function for recursive splitting of BasicExpression arrays
function splitAndClausesRecursive(