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

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 :)