SQL-92 GUI client

Hi,

I client of mine is extracting data from their production database into MS Excel using MS Query via SQL-92 Progress ODBC. They query up to three connected Progress 10.2B database at any given time. Developing queries (select, drag and drop) is no longer an option since they migrated to 102.B which only uses SQL-92. They now have to manually type SQL commands as field names need to be prepended with database names, table names etc. Table names furthermore require an underscore (_) and 0 qualifier appended to the field name. From my investigation this seems to be caused my the MS Query Tool.

For a simple select with one or two fields it may not be too much or an issue. However when you start to create queries with several fields from different databases the situation becomes error prone and tedious. Best practice is obviously to have a seperate reporting database however this does not address the issue at hand.

Is there another SQL GUI tool available (free/paid) where the end-users who by nature are not full-time developers can utilize instead? Noting that the resultant data would still need to be stored in a spreadsheet format as a minimum. If a dedicated reporting engine can be proposed as apposed to using MS Query, which will mitigate the necessity to pre/append field names allowing the end-user to use select, drag and drop features for the better part of query creations, I would also appreciate your feedback.  

Please let me know if any specific information is required or alternative best practices we need to investigate.

Kind regards,

Edgar