Range lookup with complex expressions

I just confirmed, this is a Sqlite engine issue. I can recreate your results by using it as the database engine. From reading through the docs a bit more, this appears to make sense, given that Sqlite3 doesn’t have a “DateTime” data type. (See Section 3.2 at Quirks, Caveats, and Gotchas In SQLite)