The iterdump docs promise the following:

Return an iterator to dump the database as SQL source code.

The current implementation has several drawbacks compared to the SQLite shell .dump command. We should try to align our implementation with the .dump command of the SQLite shell.

See also #64662

Linked PRs

• gh-108364: In sqlite3, disable foreign keys before dumping SQL schema #108471
• gh-108364: Simplify quoting values and identifiers in sqlite3's iterdump() #108472
• gh-108364: In sqlite3, disable foreign keys before dumping SQL schema #113957