T-SQL language improvements
Data Warehouse · Public preview · Planned
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.
Change History
-
2026-08-24
Roadmap Item Added
Workload: Data Warehouse