DVC doesn't work with recommended sqlite3 settings: double-quoted string off (`DQS=0`)

Opening a fresh issue for this for visibility.

I think in principle DVC should work with the recommended sqlite settings which is DQS=0

In other words, I would benefit if DVC would only emit standards-compliant string literals (single quotes rather than double).

For example, on FreeBSD the port for sqlite3 defaults to DQS=0 so to use DVC on FreeBSD requires jumping through some hoops.

For my case, I've just pinned python-diskcache to a patched fork for now, but I'd rather not have to. Perhaps this issue could be re-opened and renamed or I could open a new one under 'Support sqlite with DQS=0' if preferred. Let me know

Cheers

Originally posted by @jaredkhan in #10692