Is it possible to run Window queries on SQLite? I think it's not! Firebird implements quite a few of these statements.

I integrated most commercial db vendors and we even ran queries on imported data in a HSQLDB database. Firebird is just way ahead of HSQLDB, and HSQLDB is similar to SQLite feature-wise.

I don't mean it would be cool to be able to export to Firebird. I mean that you might want to use Firebird as your underlying engine :)