feat: add volatile scalar function `instance_uuid`

Summary

• feat(sql): support volatile scalar functions

Implement instance_uuid function.

---

• Close #1282 (closed)
• Cherry-pick to: none
• Docs follow-up: #1718 (closed)
• Changelog is updated