I agree, I work on an application with a lot of business logic in SQL and SSMS ends up being my primary development IDE because of that.
Lead PM for SQL in VS Code here. I’m glad to hear SSMS is working well for you! I’d love to better understand why VS Code doesn’t meet your needs in the same way.
We’re actively working to improve the experience, and learning what works for you in SSMS would be incredibly valuable.