DuckDB also supports the PIVOT keyword (for creating pivot tables), window functions and QUALIFY clauses to filter them, and many other analytics functions in its SQL dialect. DuckDB extensions ...

Microsoft makes additional speed-up claims for specific cases for SQL Server 2016 versus SQL Server 2014; some of these are very specialized, such as “19x faster Spatial native functions,” and ...