The following scenarios would be the best fit for building SQL on Azure VMs:
- Migrating existing apps on-premises to Azure with minimal changes
- Having a SQL environment wherein you have full access to it
- 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