Support duckdb's INSERT OR IGNORE INTO ...

[qazxcdswe123]

Is your feature request related to a problem or challenge?

I'm interested in GSoC Ergonomic SQL Features and found INSERT OR IGNORE INTO ... to be missing (while INSERT OR REPLACE INTO is supported)

I'd like to take this as a warm-up project but not sure if this feature is needed and will be accepted so I'd like to ask if we need this feature before starting to implement it.

Describe the solution you'd like

Implement duckdb's INSERT OR IGNORE INTO ...

Describe alternatives you've considered

INSERT ON CONFLICT, but I'm very surprised that this is not supported.

Additional context

• https://duckdb.org/docs/stable/sql/statements/insert.html#insert-or-ignore-into

Any feedback or guidance would be much appreciated! Or if there are any other suggestion on the warm-up project, let me know!