We are just starting into using ODBC with NetSuite and are having a heck of a time getting queries that work. I have looked through the training videos, which look old, and the user guide, which lists a few restrictions. Are there other resources I am not aware of that would help me understand the unique requirements of using the connector? What tools do others use for developing queries against the ODBC?

Here is an example of something I am trying to do:

select S.Name, Ten.OppCount as [Ten Count], Ten.OppTotal as [Ten Total]
from Sales_Reps S