microsoft / microsoft/vscode-mssql
[Feature Request]: Wildcard expansion in INSERT clause - Populate list of table fields
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 1.9k
- Forks
- 610
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 97
Description
the extension already has wildcard expansion for SELECT statements.
I think it'd be simple enough to do for INSERT clause too.
Example of mssql extension doing SELECT * wildcard expansion. Feature request is for **INSERT** clauses too
`INSERT INTO dbo.MyTable`
example references in other extensions:
* https://docs.devart.com/studio-for-sql-server/writing-and-executing-sql-statements/wildcard-expansion-in-sql-statements.html
* https://docs.devart.com/sqlcomplete/writing-sql-with-code-completion/statement-expansion.html#:~:text=after%20the%20*%20symbol.-,Expand%20the%20INSERT%20statement,-This%20feature%20allows
* * Note in this example, this populates the VALUES clause with dummy data. this is not strictly necessary
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No file, test, or entry point is named. Start by locating the existing SELECT wildcard expansion referenced in the issue, then trace how completion handles INSERT INTO dbo.MyTable; done means pressing Tab can populate the table's field list without requiring dummy VALUES data.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, typescript
- Domain
- databases, tooling
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100