How to Avoid Common Pitfalls When Using `Where`, `AndWhere`, and `OrWhere` Clauses Together in Doctrine Queries with Expression Language

Understanding and Resolving the "DATE" Key Issue with Doctrine Query Language in Symfony 5