As Mariano said, it’s quite dangerous if exposed - and abused. If you want to have Static collections, you can call Supabase via the REST endpoints that each Supa project has and use the REST Plugin in WeWeb to get Static Collections. As REST lets you have them. Then everything should work.
Supabase by default creates a REST API layer around your project (tables, functions etc.), you can write a stored procedure/view in Supa and call it via REST to get the data, it’s really as simple as that.