Enhanced SQL Query Management for Supabase CLI: A Proposal for Query File and Folder Support

Feature Request Introduction Supabase is a popular platform for building and managing databases. However, the SQL Editor in the Studio Dashboard falls short when it comes to advanced use cases that require the utilization of AI-powered solutions. To solve this issue, we propose a new feature for the supabase CLI - the ability to run SQL queries from user-created files stored in a specified directory. The Feature The new feature would allow developers to store SQL queries in a directory with a specified structure. The directory would have a unique name, and within it, there would be subdirectories that represent the different modules, projects, or teams that use the queries. The SQL queries would be saved as individual files with meaningful names that describe their content. Developers could write their SQL queries in their preferred code editor or IDE and save them in the appropriate subdirectory within the query directory. When they want to run a query, they would use th…