CREATE TABLE succeeds when schema has duplicate names, resulting in a table that cannot be selected from

### Describe the bug

CREATE TABLE succeeds when schema has duplicate names, resulting in a table that cannot be selected from

### To Reproduce

```
> CREATE TABLE t AS SELECT * FROM (SELECT 1 AS id, 'Foo' AS name) l JOIN (SELECT 1 AS id, 'Bar' as name) r ON l.id = r.id;
0 row(s) fetched.
Elapsed 0.016 seconds.

> SELECT * FROM t;
Schema error: Schema contains duplicate qualified field name t.id

> SELECT count(*) FROM t;
Schema error: Schema contains duplicate qualified field name t.id
```

### Expected behavior

If `CREATE TABLE` succeeds, the table should be readable.
If the table is not going to be readable (and we know this at create time), the `CREATE TABLE` should fail.

### Additional context

_No response_