Reverse engineering SQL

[BB <adamnt42@xxxxxxxxx>]

(not so trivial)

Summary:

Can anyone suggest

1) how to insert a string (of SQL) into an SQLRequest and have it parsed 
into an SQLRequest object

or

2) have a Connection "compile" a string of SQL, not execute it just make 
the internals of a Result available for further use. Sort of like

    myResult = Conn.Compile(sQuery)
    With myResult.Fields
        ...
    End With

or

3) another way to get information about the query similar to what the 
Connection editor does for tables in the IDE

I have some "fixed" query strings that I want to get into some 
structured object so I can do some manipulation of a grid I use to 
display the results. Like setting the column count and headers. The 
query string is "incomplete" in that it has substitutable WHERE clauses 
and ORDER BY clauses so I cant execute it at the time I am setting up 
the grid.

tia

bruce