Linked lists or details list for bigquery data

Hi community,

My app is based on bigquery data. I have the most common use case for a detailed list: in my list i have customers and from customers i want zoom in into projects, so i see the details of that customer.

In airtable this is super easy to setup, however bigquery connections dont support list details. What would be the best workaround?