Does Duck DB support triggers?

Viewed 12

I suspect the answer is no, but I just wanted to check if anyone has a way to implement triggers in DuckDB?

I have a SQLite database that relies heavily on views with INSTEAD OF INSERT/ UPDATE/ DELETE triggers to mask the underlying table structure from applications. Having heard good things about DuckDB I was hoping to try a port, but the lack of triggers (or an alternate mechanism for achieving the same goal) is a show stopper. I've no great desire to reimplement all of the functionality in the various host languages that access the database.

0 Answers
Related