The following scenarios would be the best fit for building SQL on Azure VMs:
- Migrating existing on-premises apps to Azure with minimal changes
- Having a SQL environment that you have full access to
- Needing databases of up to 64 TB storage, since Azure SQL Database can support only up to 4 TB
- Building hybrid applications with SQL Database as a backend