insights: refactor search query results to extract repository name

Created by: coury-clark

Closes # #23386 (closed)

Refactors the search query handler for code insights to drop a commonly used db call in favor of extracting the result out of the search result.

As a bonus, this refactors the search query handler to skip errors during recording and capture them as a multierror, stopping some inconsistent behavior where results can fail midway through processing.