[BUG] Set up mapping between spec repo folder and SDK repo folder for SDK automation

[live1206]

Library name and version

Azure.ResourceManager.Sql

Describe the bug

Right now, in spec repo the folder is sql.
But, in azure-sdk-for-net the folder is sqlmanagement.
This mismatching is causing failures of .NET SDK track 2 automation for swagger PRs of sql.

Expected behavior

The folder names should align.

Actual behavior

Folder names do not align.

Reproduction Steps

Azure/azure-rest-api-specs#24349 (comment)
.NET SDK Track 2 automation is failing.

Environment

No response

[live1206]

After discussing with @m-nash, we can't guarantee to align the folder structure for all RPs.
There are cases some RPs are sharing the same swagger folder, but they would like to release their SDKs separately, which end up into different SDK folders.

There is a property specifying the SDK structure in TypeSpec, we can have something similar in .NET SDK automation to have the mapping between swagger folder to SDK folder.

[tdoshin]

Can this be closed? @live1206

[live1206]

@tdoshin Not really, this still needs to be fixed, renamed to repurpose.