Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

Bigquery wrapper fails when trying to query a foreign table inside a view and blocks every single operation after that.

[2024-11-25 20:02:17] [57014] ERROR: canceling statement due to statement timeout
[2024-11-25 20:02:17] Where: while inserting index tuple (0,54) in relation "wrappers_fdw_stats"
[2024-11-25 20:02:17] SQL statement "insert into extensions.wrappers_fdw_stats as s (fdw_name, create_times) values($1, $2)
[2024-11-25 20:02:17] on conflict(fdw_name)
[2024-11-25 20:02:17] do update set
[2024-11-25 20:02:17] create_times = coalesce(s.create_times, 0) + excluded.create_times,
[2024-11-25 20:02:17] updated_at = timezone('utc'::text, now())"

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Create a foreign table
2. Create a view with a WITH query that references the foreign table
3. Execute a simple select on the view

Expected behavior

Select returns

System information

• OS: macOS
• Browser (if applies) chrome