microsoft / microsoft/vscode-mssql
[Feature Request]: jupiter notebook SQL CTE style support
- 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.