Enhancing Developer Experience with Client-side Raw SQL Queries

Hello, I wanted to bring up an idea that I believe could significantly improve our development experience with Supabase: the ability to run raw SQL queries directly from the client. Now, I understand that we already have options like views, RPC, and edge functions to execute queries. However, it adds unnecessary complexity and work. Instead of creating a view / RPC / endpoint, you could simply query the data you need. Of course, it's essential to address the security aspect associated with executing raw SQL queries from the client. To mitigate potential risks, I propose starting with a limited scope, allowing only SELECT queries initially. By doing so, we can ensure that we prioritize security while still reaping the benefits of this feature. Some practical examples of how running raw SQL queries from the client can empower us to achieve things we currently cannot: • sum • group by • distinct • coalesce • where exists(…) • c…