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