[TypeSpec] Generate SDK for TypeSpec project specification/sql/resource-manager/Microsoft.Sql/SQL

[azure-sdk]

SDK generate request for TypeSpec projectspecification/sql/resource-manager/Microsoft.Sql/SQL

Request to generate SDK by Copilot. Do not release SDK
SDK will be released later by service owner.

Release Plan: 2227
TypeSpec project path: specification/sql/resource-manager/Microsoft.Sql/SQL
API spec pull request link: #41520
Spec Type: TypeSpec
Language: Python,.NET,Java,JavaScript,Go
Release plan work item ID: 34310
Plane: Management-Plane
API version:

Contacts: jeremyfrosti

Notes:
SDK is generated by GitHub agent workflow

Generate SDK for the TypeSpec project and update the generated SDK details in the release plan using release plan work item. Generate a summary and update it back in the linked GitHub issue once SDK pull requests are generated.

[github-actions]

SDK Generation Triggered 🚀

SDK generation pipelines have been successfully triggered for Azure SQL Database (TypeSpec project: specification/sql/resource-manager/Microsoft.Sql/SQL, API version: 2025-01-01, release type: stable).

Language	Pipeline
Python	Build 6276192
.NET	Build 6276193
Java	Build 6276194
JavaScript	Build 6276195
Go	Build 6276196

Monitoring pipeline completion and SDK PR links... Will update this issue once SDK pull requests are available.

Generated by SDK Generation Agent for issue #43053 · ● 5.1M · ◷

[github-actions]

SDK Generation Summary

SDK generation for Azure SQL Database (specification/sql/resource-manager/Microsoft.Sql/SQL, API version 2025-01-01, stable) has completed.

SDK Pull Request Status

Language	Status	SDK Pull Request
✅ Go	Completed	azure-sdk-for-go#26747
✅ Java	Completed (draft)	azure-sdk-for-java#49142
✅ JavaScript	Completed (draft)	azure-sdk-for-js#38485
❌ .NET	Failed	Build 6276193
❌ Python	Failed	Build 6276192

---

❌ SDK Generation Failures

.NET — Pipeline 6276193

Root cause: TypeSpec compilation error in client.tsp — the clientDefaultValue member does not exist in the Azure.ClientGenerator.Core.Legacy namespace.

error invalid-ref: Namespace Azure.ClientGenerator.Core.Legacy doesn't have member clientDefaultValue
  at sdk/sql/Azure.ResourceManager.SQL/TempTypeSpecFiles/SQL/client.tsp:103, 112, 121, 130, 139, 148
```

**Fix:** Update the `client.tsp` file in the `azure-sdk-for-net` repository to remove or replace usages of `Azure.ClientGenerator.Core.Legacy.clientDefaultValue` with the correct decorator from the current `@azure-tools/typespec-client-generator-core` API.

---

#### Python — [Pipeline 6276192](https://dev.azure.com/azure-sdk/internal/_build/results?buildId=6276192)

**Root cause:** Breaking change detection failed due to a missing `six` module in the pipeline environment, causing changelog generation to fail.

```
ModuleNotFoundError: No module named 'six'
[ERROR] Breaking check failed for azure-mgmt-sql: detect_breaking_changes.py returned non-zero exit status 1.
[INFO] [PACKAGE](azure-mgmt-sql)[CHANGELOG]: change log generation failed!!! You need to write it manually!!!

Fix: This appears to be a pipeline infrastructure issue with the missing six dependency. Retry SDK generation, or manually write the changelog. If the issue persists, contact the Python SDK team.

---

Troubleshooting

To troubleshoot SDK generation failures locally:

1. Clone the azure-rest-api-specs repository.
2. Open the cloned repository in VS Code and use GitHub Copilot Chat with a prompt like "generate SDK locally for .NET" or "generate SDK locally for Python" to troubleshoot the error.
3. Make any required TypeSpec changes to fix the SDK generation errors, then re-trigger SDK generation.

---

sdk pr for Go: Azure/azure-sdk-for-go#26747
sdk pr for Java: Azure/azure-sdk-for-java#49142
sdk pr for JavaScript: Azure/azure-sdk-for-js#38485

Generated by SDK Generation Agent for issue #43053 · ● 5.1M · ◷