Implement OR Condition in where Clauses

[teles]

Implement OR Condition in where Clauses

Description:

Add support for logical OR conditions in where clauses, allowing queries to return records that meet at least one of the specified conditions.

Objective:

• Enable the combination of multiple conditions using logical OR 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: { OR: [{ condition1 }, { condition2 }] } }) returns records that meet at least one of the specified conditions.
• Documentation updated with examples demonstrating the use of OR.
• Automated tests cover various scenarios of combined conditions.

[teles]

No progress yet

WhereService currently only supports intersection (implicit AND) of per-key matches. No OR logic exists.

❌ Still needed: Top-level OR combinator:

findMany({ where: { OR: [{ status: 'active' }, { role: 'admin' }] } })

WhereService needs to detect the OR key and union the matched rows across the array of sub-clauses.