Since MSSQL is built for Windows and Linux, you cannot install it directly on macOS. You must run it inside a Linux container.
docker pull mcr.microsoft.com/mssql/server
This is Microsoft’s free, cross-platform successor to SQL Server Management Studio (SSMS). It looks and feels like VS Code.