Hi there.
As far as i know, you cannot use the old collection SQL queries in NS7, because of the table name changes etc. However, when you upgrade from NS6 to NS7, collections can be converted to filters, but will not be dynamic and will be read only.
I also only recently started using NS7, and my initial thought was "What a crap way of creating filters" - Not true.
I am building custom filters like there is no tomorrow, the nice thing about learning this way is that you could then also build reports the exact same way.
You need to firstly select your query builder mode, then change your base query from resource to computer, thereafter you need to select the fields you would like to work on and then add your filter expressions. Just like in the old NS6 collections, but a bit different.
Believe me when i say - you'll love it!
E