Add suport for listing all available tables

[Rednas83]

Is your feature request related to a problem? Please describe.
Client is unaware of the available tables that can be accessed.

Describe the solution you'd like
const { data: tables } = await supabase.from() // Returns ["projects", etc]

Describe alternatives you've considered
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';

Additional context
https://github.com/orgs/supabase/discussions/33945#discussioncomment-12368707

[silentworks]

I don't think this is the correct repo for this to be opened on. Also what is stopping you from calling the SQL you listed above? this sort of thing should never be a part of the public API of the Supabase SDK as this would be providing potential attackers with an avenue to know and test each of your tables to see if RLS is enabled.

[Rednas83]

The sql query feels a bit like a hack and I also doubt wheter it wil work as expected because I am only interested in the table names that the authenticated user has acces too in order to be able to populate the correct navigation

I agree that only authenticated users should be able to acces the names of the tables.

Perhaps put it behind a flag?

Something like
discovery of tables = true