While it's true that native GA4 to BigQuery backfilling isn't currently available, I've built a tool at databackfill.com that helps solve this problem. You're right that 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. let us know what you think