Blob Containers can read the full Storage Account URL

[JFolberth]

Is your feature request related to a problem? Please describe.
When creating and referencing a container within an Azure Storage account it would be nice not to have to rely on string interpolation to reference said container.

This came to light when doing SQL Server vulnerability assessments which requires the container path. It works with something like:

${storageAccountVulnerability.properties.primaryEndpoints.blob}${storageAccountContainerVulnerability.name}

Would love to be able to reference this with a property off of storageAccountContainerVulnerability in this case.

Describe the solution you'd like
Reference something like
storageAccountContainerVulnerability.properties.URL
This value is available in the portal.

[alex-frankel]

If it's not returned by the API, there is not a lot we can do other than "fake" it in Bicep which is covered in #2085