xialvjun / xialvjun/ts-sql-plugin
vscode improvements
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 195
- Forks
- 10
- PR merge metrics
- No merged PRs in 30d
Description
Thanks for the plugin, it's awesome, I hope you continue to support it.
@xialvjun @darky
I don't know exactly which side this process takes place on (vscode or typescript plugin)
but I would really like that when writing a query with a specific table (FROM users)
I would get the columns of particular table, not from others.
Got:

Expected:

It would be very cool to have autocomplete for columns when writing queries like
SELECT users.id
^^ - show available columns of users table here
FROM users
And while writing queries like
SELECT
^^ - show available columns of users table here
FROM users
without specifying a table (take from "FROM" sql part)
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 files or tests are named. Start by reproducing the SQL examples in VS Code and trace the TypeScript language-service plugin's completion entry point; done means table-specific column suggestions work for qualified and unqualified SELECT expressions based on the FROM table.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, typescript, vscode
- Domain
- databases, tooling
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100