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.