> For the complete documentation index, see [llms.txt](https://til.duyet.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://til.duyet.net/db/google-bigquery/bigquery-unnest-in-select.md).

# BigQuery - UNNEST in SELECT

We can use `UNNEST` in the nested fields, rather than unnesting in the WHERE clause and JOIN

```sql
SELECT 
    event_name,
    (SELECT value.int_value FROM UNNEST(event_params) WHERE key = "value") as score,
FROM `example_*`
```