This utility exists to allow OBI report writers to more easily parse through the SQL that OBI spits out for Answers analyses.

Paste OBI SQL into the first box.
Hit "Generate Distinct Col List" to get a distinct list of columns used in the SQL with all of the "T%" aliases replaced with their corresponding table.
Hit "Unalias Query" to have the "T%" alias mapping applied to the query you pasted in (useful for seeing the join logic, returned columns, etc.). If the same table is used multiple times in your query with different aliases, the second, third, etc. copy of the table will have a number placed at the end to distinguish these copies in the final query.
Hit "Unalias Query (and remove col aliases)" to have the "T%" alias mapping applied to the query you pasted in. If the same table is used multiple times in your query with different aliases, the second, third, etc. copy of the table will have a number placed at the end to distinguish these copies in the final query. Also, the column aliases ("Table.Column as c123) are removed, so that the query (if it is still runnable) will show the actual columns returned, rather than the c1, c2, c3, etc. column aliases.