No, I actually like SQLite with the settings tweaked a tiny bit. Disagreement with the defaults isn't enough to make me switch databases completely
DuckDB is a OLAP database. Its optimized for batch analytics, not for individual transactions. Its great for data science work, but I wouldn't use it for a production system.
What are the defaults for duckdb? Is it the pragma 2026 equivalent?
I can't speak for speed, but foreign keys and data type checking are on by default.