[Milhouse]

@purpleman: I've pushed an update (v1.9.0) that resolves the field mapping issue, so that you can now query using the JSON API instead of direct SQL.

Code:

python.exe texturecache.py x "where lastusetime like '2015-01-01%'"

would return any item last used on 2015-01-01.

Code:

python.exe texturecache.py x "where lastusetime < '2015-01-01'"

would return any item last used prior to 2015-01-01.