[Issue] azure sql not printed during `azd provision`
Run azd up -t todo-csharp-sql or any template that uses Azure SQL
You'll see this:

Azure SQL isn't in the list when it should be.
The mapping from RP types to friendly names is here:
https://github.com/Azure/azure-dev/blob/e5acbfe8bcfe001abbbf9457e5d660dc1a727132/cli/azd/pkg/infra/azure_resource_types.go#L31-L63
If we don't return a value from this function, we don't display something in the output:
https://github.com/Azure/azure-dev/blob/e5acbfe8bcfe001abbbf9457e5d660dc1a727132/cli/azd/pkg/infra/provisioning/provisioning_progress_display.go#L117-L118
Can we switch this to parse the enum so it can be dynamic and future proof?
ie. When we get AzureResourceTypeStaticWebSite we print Static Web Site.
- Remove "AzureResourceType"
- Take the rest and split on upper case letters and add a space between them.
We never know what future RP will be there and we don't want to have to do a CLI release to support any unknowns.
@jongio The enum itself is a static list, so it still won't be future proof. I had omitted SQL when it was originally defined in the enum list because it wasn't used anywhere. In hindsight, I should have just mapped the translation.
To address the current issue, we should just map the translation for now, by adding an entry to GetResourceTypeDisplayName @hemarina, because doing the dynamic translation for all RP types is a lot more complicated, and I still haven't found a good way of doing so. See #180
Can we do a bulk manual add for now that includes all resources?
@vhvb1989 can you also fix this as part of #1186