Mike if you are working on dates, I also noticed that SqliteExplorer parses dates in sql statements (even with "Use Datatypes" off). As a simple example, the following works fine with sqlite directly but not through SE
SELECT DATE('2005-04-02T00:00:00')
Thanks,
-Brad
