Implement AND Condition in where Clauses

[teles]

Implement AND Condition in where Clauses

Description:

Add support for logical AND conditions in where clauses, allowing more complex and precise data filtering in queries.

Objective:

• Enable the combination of multiple conditions using logical AND in queries.
• Update the syntax of the where parameters to support arrays or objects representing combined conditions.
• Ensure the implementation is intuitive and consistent with existing filtering functionalities.

Acceptance Criteria:

• Calling findMany({ where: { AND: [{ condition1 }, { condition2 }] } }) returns records that meet all specified conditions.
• Documentation updated with examples demonstrating the use of AND.
• Automated tests cover various scenarios of combined conditions.

[teles]

Partial progress

✅ Done: Multiple keys in where are already treated as implicit AND — WhereService intersects the matched rows from each key, which is logically equivalent to field1 AND field2.

❌ Still needed: Explicit top-level AND combinator syntax per the acceptance criteria:

findMany({ where: { AND: [{ name: { equals: 'Alice' } }, { age: { gt: '30' } }] } })

WhereService needs to detect the AND key and fold across the array of sub-clauses.