[Feature Request]: tab name when using Script as alter/create

### Feature Description

when using the script to alter/create function to edit a database object, it would be ideal that the tab name for the file opened would get the name of the object being edited.
This would also help with saving the file locally... the file receive the name of the object directly.

### Problem and Motivation

This seems like a small change but would greatly improve time wasting on dull actions.
As I remember, this was the default behavior in Azure Data Studio.

### Related Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [x] Query editor
- [ ] Query results panel
- [x] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the area

_No response_

### Confirmation

- [x] I have searched existing feature requests and couldn't find a match
- [ ] I want to help implement this feature