dbt-labs / dbt-labs/dbt

[FEAT] Support star-expansion of columns in vscode

Open
#13,666 2 comments 2 reactions 0 assignees View on GitHub
area:vscode engine:v2 type:feature
Dominant language
Rust
Stars
13.8k
Forks
2.6k
Avg merge
21h 31m
Merged PRs (30d)
56

Description

This request partly relates to https://github.com/dbt-labs/dbt-fusion/issues/650 but is slightly different.

**Is your feature request related to a particular component of the dbt Fusion Engine**
- [ ] CLI Features
- [ ] Adapter or Database Driver Features
- [ ] SQL Understanding Features
- [x] VS Code extension

**Describe the solution you'd like**

A competing IDE includes this feature for SQL and dbt:

* place the cursor onto a star character within a SELECT statement,
* press the right hotkey (or use corresponding nav menu)
* the IDE expands the star into all of its underpinning columns

See below demo.

This is an ***incredibly useful feature***, because it saves us having to write out every single column, every single model.

(Instead, developers can use the star expansion, and then just peel it back to the columns they care about).

https://github.com/user-attachments/assets/c894d2bf-eed3-46f9-87f4-ee6098ffdd9f

```sql
WITH foo AS (
SELECT
column1 AS colour,
column1 AS foo,
column1 AS bar
FROM (VALUES ('a'))
)

SELECT
colour,
foo,
bar
FROM foo
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.