Description
Is your feature request related to a problem? Please describe.
Visual Studio allows you to add new .sql scripts to a database project that receive a build action of "None". There currently doesn't seem to be any way of doing this in ADS / SQL Database Projects extension for legacy .sqlproj projects.
Describe the solution or feature you'd like
When I try to add an item to a database project, I'd like to see "Script (not in build)" as an option. When selected, it adds a new file with a build action of "None" (i.e., <None Include="MyScript.sql" />).
Describe alternatives you've considered
The alternative I am going with is adding files to the project in Visual Studio and using an "Open in VS Code" extension to switch to VS Code after it has been added. Looking at the code it seems that Publish Profiles get added with a "None" build action, so an alternative is to add a new publish profile and then rename the file.