T-SQL language improvements

Data Warehouse · Public preview · Shipped

Data Warehouse Public preview Shipped
Last Modified: October 08, 2026 Release Date: Q4 2026

Description

New capabilities focused on making T-SQL more powerful for analytics, simpler to write, and more intuitive for data exploration.<br/>* **Advanced Analytics** Expanded statistical capabilities with functions such as `MEDIAN`, `QUANTILE`, `PERCENTILE`, `APPROX_MEDIAN`, and `APPROX_QUANTILE` for distribution analysis and large-scale analytical workloads.* **Simplified Query Syntax** New language constructs including `QUALIFY`, `GROUP BY ALL`, and `ORDER BY ALL` help reduce query complexity and improve readability of analytical queries.* **More Intuitive Querying** Developer-friendly syntax enhancements designed to make common query patterns easier to express, improving productivity and reducing the amount of code required to answer business questions.

Change History

  1. 2026-10-08
    Release Status Planned -> Shipped
  2. 2026-08-24
    Feature Description ## T-SQL Language EnhancementsNew capabilities focused on making T-SQL more powerful for analytics simpler to write and more intuitive for data exploration.- **Advanced Analytics** Expanded statistical capabilities with functions such as `MEDIAN` `QUANTILE` `PERCENTILE` `APPROX_MEDIAN` and `APPROX_QUANTILE` for distribution analysis and large-scale analytical workloads.- **Simplified Query Syntax** New language constructs including `QUALIFY` `GROUP BY ALL` and `ORDER BY ALL` help reduce query complexity and improve readability of analytical queries.- **More Intuitive Querying** Developer-friendly syntax enhancements designed to make common query patterns easier to express improving productivity and reducing the amount of code required to answer business questions. -> New capabilities focused on making T-SQL more powerful for analytics simpler to write and more intuitive for data exploration.<br/>* **Advanced Analytics** Expanded statistical capabilities with functions such as `MEDIAN` `QUANTILE` `PERCENTILE` `APPROX_MEDIAN` and `APPROX_QUANTILE` for distribution analysis and large-scale analytical workloads.* **Simplified Query Syntax** New language constructs including `QUALIFY` `GROUP BY ALL` and `ORDER BY ALL` help reduce query complexity and improve readability of analytical queries.* **More Intuitive Querying** Developer-friendly syntax enhancements designed to make common query patterns easier to express improving productivity and reducing the amount of code required to answer business questions.
  3. 2026-08-24
    Roadmap Item Added
← Back to Roadmap 👁️ Watch this Feature View API JSON Workload: Data Warehouse