microsoft / microsoft/vscode-mssql

[Feature Request]: jupiter notebook SQL CTE style support

Open
#22,032 0 comments 0 reactions 1 assignee Claimed by @croblesm View on GitHub
Area - SQL Notebook Enhancement Triage: Needed User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Feature Description

When writing a Jupiter Notebook with SQL, it would be amazing to have a CTE style support. Usually I structure my query with
1. loading required tables, columns - 1st cell
2. transform tables - 2nd cell
3. apply business logic - 3rd cell

that is more or less the overall structure. Between each step it should be possible to insert markdown descriptions.

### Problem and Motivation

With the current version one cell needs to be a complete query, so I get an error when just defining the load table CTE cell, as it is just one part of the query.

### Related Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [ ] 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
- [x] Other (please describe below)

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

SQL Notebooks

### Confirmation

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

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.