Deleting rows from a CSV file, based on date column value.

[Schmidt]

I'd also advise avoiding SQLite like the plague.

Which is really bad advice (apparently given by someone who doesn't use it,
because any SQLite-using developer I know of, will disagree with you on that).

It tends to be especially iffy on Windows,

No, it is definitely not.

where data access libraries for it often embed old buggy versions statically compiled in so they can't be updated.
Some bungle character encoding, doing things as silly as UTF-16LE to UTF-8 on write but returning UTF-8 on read. Others have really poor performance overall and mangle BLOB data unpredictably.

Such old wrappers should be specified by you here exactly, so that people can avoid these
"old wrapper versions".
So which ones did you test and based your opinions on?

For VB6 there's two current (free and well-maintained) SQLite-wrappers, which show none
of the alleged issues you mentioned above.
The free ODBC-Driver from Christian Werner:
http://www.ch-werner.de/sqliteodbc/

And the download-wise less voluminous VB6-based wrapper (faster - and with more directly
accessible "native SQLite-functionality") which comes with the vbRichClient5-Framework:
http://www.vbRichClient.com

If you are going to use it look for a commercial SQLite OLEDB Provider.

Bad advice again, since both of the above mentioned, free SQLite-wrappers are
out there for more than 10 years, hardened over time and actively maintained.

... but TEST, TEST, TEST. You may have to try several.

Given the context of SQLite, that's a quite "FUD-ish" statement, because any
SQLite-version has to pass one of the largest Test-Suites on this planet
(Millions of Tests) before becoming a new release. Please inform yourself on:
https://www.sqlite.org/testing.html
before posting such misleading statements.

That huge test-coverage is one of the reasons for its popularity in all kind of languages
(along with, that it runs on any device and supports its DB-Format unchanged across all these devices).

Plus the upshot is that it doesn't come with Windows anyway, so it becomes one more nasty to deploy.

The above will be a false statement already next month, because Win10 will officially
ship with SQLite from then on (MS has finally seen "the Light" I guess).

Olaf