SQL Project building from non-C# projects

### Related to an existing integration?

Yes

### Existing integration

CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects

### Overview

Right now non-C# projects can only reference a built dacpac. They can't reference the project itself.

Would love to see support added for the projects themselves to streamline things.

### Usage example

Basically add an sqlproj project and not need to have the dacpac pre-built. Otherwise, everything functions similarly as with C# today.

### Breaking change?

No

### Alternatives

N/A

### Additional context

_No response_

### Help us help you

No, just wanted to propose this

Start by inspecting the CommunityToolkit.Aspire.Hosting.SqlDatabaseProjects integration and how it currently handles references to built dacpacs, then compare that behavior with C# project references. Done means a non-C# sqlproj can be referenced directly without a pre-built dacpac while preserving the existing integration behavior.

Written by the indexing model from the issue text.