Best practice for table component with JOIN

I think I fixed it.

I am not SQL-joining tables as the source of the Retool table component, but adding custom fields, using the following template:

{{ getPortfolios.data.portfolio_name[currentRow.portfolio_id] }}