Save Query as Object
While designing a query user should have possibility to save Query as Object - Microsoft Access approach.
Then user comes back to this query and re-use: execute or modify.
This would be advantage for those projects where user operates with similar entities.
Use Scenario: I create a query "Active Users", save this query.
Then I write another query which uses entity "Active Users". In my new query designed I drag and drop existing query as Table and e.g. join real table with "Active Users" entity.
-
Bill Powell commented
I agree. This is a feature provided by a competitive product, Navicat. They are simply saving .sql files, but provide the interface to retrieve them and to cut/paste them between like databases.