DuckDB offers a SQLite compatible interface; we use it extensively ourselves as it allows us to use the SQLite shell directly. The internal design of DuckDB, h

DuckDB offers a SQLite compatible interface; we use it extensively ourselves as it allows us to use the SQLite shell directly. The internal design of DuckDB, however, is different and not directly related to SQLite. As you mentioned, it is entirely optimized for analytical workloads whereas SQLite is optimized for point-queries and point-updates. The main things we share is that we also have a single-file storage format and offer an amalgamation (i.e. single-source file compilation, duckdb.cpp and duckdb.hpp).