Our reference database is Netezza (aka IBM Pure Data) and we have purchased ADS to develop queries, views and stored procedures for Netezza and Oracle.
The query tool we are trying to replace is SQuirreL, but there are some important features that we do not find in ADS.

The case where "view in object tree" is useful is when I have to understand a complex SQL query to (for example) optimize it for performance.

So, in the Query Analyzer window there is a text "select (...) from table1 t1 join table2 t2 on t1. k=t2. k=t2. k join table3 t3 on t2. k=t3. k where (...)" and I want to see how a table is (fields, field type, constraint).

To quickly search for the table (or view) in the object tree, I’d like to place the cursor on the table name in the Query Analyzer and press a key combination (in SQuirreL is Ctrl-B) which calls the function "view in object tree".

The function opens the ObjectTree and positions the focus on the correct table (or view).

This is much faster than (1) clicking on the connection in the object tree, (2) select the db of interest, (3) click on tables and (4) search the table by typing the name.