Hi,
You can create a dummy page type which purpose will be only to hold generic data, f.e. projectNamespace.Container and put your custom query there. Then you can link your query in simple repeater in a way that you already mention in the post.
For detail view of the object, you can use same repeater configuration, but modify where condition by query string (pass id of the object, or any other data that is needed, into query string on detail page) and then simply show that one object in transformation.
Best regards,
Dragoljub