MariaDB 10.2 has brought two new important querying features, Common Table Expressions (CTEs) and Window Functions. Both features provide greater expressibility to queries, thus opening up opportunities for the optimiser to provide speedups not previously achievable.
With a focus on analytical queries, we will see how to improve query performance sometimes by an order of magnitude compared to regular SQL.