Hi there, I'm new to Supabase so let me know if this already exists or is easily implementable manually: I use a lot of RPCs, and tbh they're hard to maintain and version control properly with just SQL migration files. It would be fantastic if supabase provided a way to automatically generate a "rpcs" folder that can easily be updated with the latest version at any time. Could be similar to the types.ts generation
Aniket Das suggests a feature for Supabase to automatically generate a folder for RPCs in the codebase to improve maintainability and version control. They find managing RPCs with SQL migration files challenging and propose a solution similar to the automatic generation of types.ts.
My preferred way is to keep everything in schema files (so also the latest version of your functions in a specific file for it) and then generate the migration files from there. Maybe this also helps you and covers your request: https://supabase.com/docs/guides/local-development/declarative-database-schemas