Popup Search based on a View/Synonym

I have an implementation of SuiteCRM that calls for integration with another database application. SuiteCRM only needs to contain a subset of the records from the other database, and there is a need to be able to pull some new records into SuiteCRM on an ad-hoc basis.

I have experience with PHP, but am new to the SuiteCRM’s framework. Is there a low-code way to create a Popup Search layout that searches against a SQL View or Synonym which pulls data from the other database?

Many thanks for the advice.

Can you please share your SQL view layouts ?