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).
Generally speaking, you need support of Teradata SQL syntax? I can't promise you to implement this fast, but we already have this item in our to-do list.