Cannot use CTE field in join

A query like

```SQL
WITH product AS (
SELECT product_id FROM source_products
)
SELECT product.product_id, SUM(orders.amount) FROM product
LEFT JOIN orders ON product.product_id = orders.product_id
```

will yield the error "Invalid Field specified in join : product.product_id"