If you're doing that then why not just use stored procedures? Prefix with a version and dropping them to cleanup is a one liner. The only issue is dependency t

If you're doing that then why not just use stored procedures? Prefix with a version and dropping them to cleanup is a one liner. The only issue is dependency tracking in case you change any schemas but that's an issue with any saved code in the database.