Suggestive Schema Indexing

[sandbox-apps]

Problem

Thinking about indexing while developing and writing feature is hard. After all we dont know what would be needed to be index when the application grows specially when we are talking about compound index (maybe optimized for sorting)

Suggested solution

Firestore has this kind suggestive indexing.
How does Firestore does this? By introspecting the ran query against the database schema.
I think we can also do this by looking the introspecting indices matching it in the query that being ran.
Then the supabase client will suggest in the console what must be index, or much we can tap a console link or a yes or no that will modify the supabase table to apply the schema.

Additional Context

This is suggested in the frontend code through console.log or print then click the link and will be auto added in the firebase console