Define ReplaceableProcedure and supporting SQLA components, parallel to ReplaceableFunction to create stored procedures.
See https://www.postgresql.org/docs/current/sql-createprocedure.html
Check whether SQLA / Alembic has added support for these now. May be able to simplify both this task and our codebase if so.