AzureSqlDatabase/SqlServerDatabase collation

### Is there an existing issue for this?

- [x] I have searched the existing issues

### Is your feature request related to a problem? Please describe the problem.

_No response_

### Describe the solution you'd like

Please consider supporting the setting of the database collation at runtime/deployment via .WithCollation("")

### Additional context

Sometimes it is important for applications to set the database collation which differs to the default; at present this is not supported as a first class operation using the aspire azure sql and/or sql server packages and requires a post deployment configuration change.