[Feature Request]: Show SQL Pane in Edit Data (Preview) area

[torbenhamburg]

Feature Description

In Azure Data Studio, the “Show SQL Pane” function allows users to modify the query behind the displayed data. This enables filtering using SQL clauses (e.g., WHERE column_xy = 'value') before editing rows via “Edit Data”.
Current Workflow Example:

• Use Show SQL Pane to add a filter:
  SQLSELECT * FROM [dbo].[tbl_azure_costs_monthly ] WHERE meterCategory = 'Storage'

• Then switch to Edit Data to make changes to the filtered result set.

Problem and Motivation

When working with large tables, the current Edit Data experience only supports loading all rows and scrolling through them. This makes it extremely difficult to locate specific entries that need editing.

Challenges:

• No ability to apply filters directly in Edit Data mode.
• Inefficient for large datasets—users must scroll through thousands of rows.

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
• Other (please describe below)

If you selected "Other", please describe the area

No response

Confirmation

• I have searched existing feature requests and couldn't find a match
• I want to help implement this feature