I think there was a typo in the wiki under "The most recent approach of SQLite to ISO SQL quoting". The recommended setting is -DSQLITE_DQS=0 (to enable strict DQS checking, disabling the misfeature), but this section says the recommended setting is -DSQLITE_DQS=3.

From the SQLite docs: Application developers are encouraged to compile using -DSQLITE_DQS=0 in order to disable the double-quoted string literal misfeature by default.

Cheers,
Thomas

the developers of SQLite changed their mind in the meanwhile.
the wiki page simply reflects the suggested setting at the time of the very early introduction of DQS