Introduce a new predicate simplification rule for evaluating constant `COALESCE`.

With the introduction of `QueryPredicate` simplification rule set in #3403, we can now introduce a new rule that can fold constant `COALESCE` such as:

```sql
COALESCE(NULL, 'false) -> 'false
COALESCE('true, 'false) -> 'true
```