Yes, the Content by Query Web Part (CQWP) is MOSS only. However, the API
is in WSS so you can create a custom Web Part that leverages the Content
by Query capabilities. Unfortunately, I don't have an example but there
probably is one out there on the Web.