As an analytics architect, VS has SSDT and better support for Azure Data Factory, SSIS, SSAS, SSRS, Machine Learning Services in SQL Server, Azure Streaming Analytics, Azure Blob Storage exploration, U-SQL unit testing ...

In my world all VS code is good for is writing Python.

It's a great tool, but there's a lot of legacy left in VS.