[BUG]: Cannot generate migration for materialized views due to "duplicated view name found"

### What version of `drizzle-orm` are you using?

0.35.2

### What version of `drizzle-kit` are you using?

0.26.2

### Describe the Bug

Create 1 or more views using any of `pgMaterializedView` or `mySchema.materializedView` and ensuring that names are distinct and not already in existence.

Encounter this fatal warning https://github.com/drizzle-team/drizzle-orm/blame/0.35.2/drizzle-kit/src/serializer/pgSerializer.ts:
```
Warning We've found duplicated view name across public schema. Please rename your view
 ELIFECYCLE  Command failed with exit code 1.
```

### Expected behavior

SQL for creating materialized views are generated successfully

### Environment & setup

Node v20.11.1
Postgres 17.0
Ubuntu 24.04 LTS