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