I believe someone mentioned this at a cloud event. You can install SQL on a VM role, but as Revenant said, you are responsible.

You also don't get any more flexibility in terms of I/O than a normal sized machine in Azure.