Support for ROW_NUMBER() OVER ... and QUALIFY
Flyspeed SQL Query is a great product, but there are a few small annoyances. Flyspeed doesn't seem to recognize an SQL statement like this:
ROW_NUMBER() OVER (PARTITION BY partitioncolnames ORDER BY ordercolnames)
I can successfully run the SQL if I don't click in the main (graphical) window first, but once I click in the main window it tries to format the SQL and turns it into a text statement.
It also doesn't like the QUALIFY clause (might be specific to Teradata).