feat: support rename procedure from sql

Summary

• add new ddl opcode for renaming procedure
• update sbroad submodule to get sql support
• syntax:

alter procedure "foo" rename to "bar" option(timeout=3)
alter procedure "foo"(int, int) rename to "bar"

---

• Follow-up for sbroad#564 (closed), sbroad!386 (merged)
• Target branch: master
• Changes should be cherry-picked to 24.1: no
• Docs follow-up: docs#182 (closed)