Docs incorrectly state that CREATE OR REPLACE TYPE is not supported.

[stevenlw-porpoise]

The create type page states the limitation

The CREATE TYPE clause does not support the OR REPLACE modifier.

However, this actually works fine, for example

% duckdb
DuckDB v1.4.1 (Andium) b390a7c376
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D create  type foo as struct(i integer, j varchar);
D select {i: 1, j: 'cat'}::foo;
┌───────────────────────────────────────────────────┐
│ CAST(main.struct_pack(i := 1, j := 'cat') AS foo) │
│           struct(i integer, j varchar)            │
├───────────────────────────────────────────────────┤
│ {'i': 1, 'j': cat}                                │
└───────────────────────────────────────────────────┘
D create or replace type foo as struct(i integer, j varchar, k double);
D select {i: 1, j: 'cat'}::foo;
┌───────────────────────────────────────────────────┐
│ CAST(main.struct_pack(i := 1, j := 'cat') AS foo) │
│      struct(i integer, j varchar, k double)       │
├───────────────────────────────────────────────────┤
│ {'i': 1, 'j': cat, 'k': NULL}                     │
└───────────────────────────────────────────────────┘
D select {i: 1, j: 'cat', k: 1.0}::foo;
┌─────────────────────────────────────────────────────────────┐
│ CAST(main.struct_pack(i := 1, j := 'cat', k := 1.0) AS foo) │
│           struct(i integer, j varchar, k double)            │
├─────────────────────────────────────────────────────────────┤
│ {'i': 1, 'j': cat, 'k': 1.0}                                │
└─────────────────────────────────────────────────────────────┘