xialvjun / xialvjun/ts-sql-plugin

vscode improvements

Open
#37 0 comments 3 reactions 0 assignees View on GitHub

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:
image
Expected:
195002540-93643d4c-9582-4085-9e74-22ce2f95304c

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.