I am extending AnalyticsPlus to provide dashboarding for our business units to replace a number of Crystal Reports that are generated and emailed and printed and so forth.  To accomplish this I need to develop queries to pull data from a number of different data tables in a number of databases. 

The problem I'm facing is that if I create a query and want to edit it after the first import the only way I can find to accomplish this is to open the data table and select import data to this table, then modify the query.  Unfortunately the query is one long line of sql script.  Really hard to read and edit.  I can maintain a library of .txt files in notepad or something, make the edits there and then replace the query in the table, but this is not going to be pleasant for a production system.

Anyone have any ideas?