What annoying this.. From the CLI

duckdb -c "ATTACH 'sqlitedatabase.db' AS sqlite_db (TYPE sqlite); USE sqlite_db; SELECT * FROM Windows10"

And indeed.. 68 rows (40 shown) 6 columns
Even when you choose HTML format or CSV it doesn't show all data!

Yes there is a workaround that you use .maxrows 9999 for example.

That would make the command:

duckdb -c ".maxrows 9999" -c ".maxwidth 9999" -c "ATTACH 'sqlitedatabase.db' AS sqlite_db (TYPE sqlite); USE sqlite_db; SELECT * FROM Windows10"

But still if you ask an export you want it all! And if otherwise you had used LIMIT 10 in your SQL-Query.
Real weird decision from the makers of DuckDB.