[Zope] Sql result searchs with Z Catalog

I need to somehow populate an ZCatalog index with the results of a Z SQL Method. If you are familiar with ColdFusion, it needs to have the same functionality as a Verity search on a collection (custom indexed from a query). I am having trouble seeing how this might be accomplished. Thanks, Jake Feasel