Yes, a native GA4 to BQ backfilling isnt available. We've built a tool at databackfill.com that helps solve this problem. Absolutely, the analytics data API has limitations, but we've focused on making the backfill process as straightforward as possible through a simple UI - no coding or API scripts needed.