PartitionQuery

PartitionQuery can be used to build a query with a window function See https://dev.mysql.com/doc/refman/8.0/en/window-functions.html for more details about window functions

TLDR: for each row from a query, perform a calculation using rows related to that row.

Practical example:

• show me the last 2 articles in each news category
• tell me the total articles in each category

$partitionQuery = PartitionQuery::fromQuery($articleQuery->withAutoSelects(),'category_id'); $partitionQuery->orderBy('published_at','DESC'); $partitionQuery->limit(2);

Note:

• when using the result in model context, you should make use of Query::withAutoSelects() otherwise timestamp and binary columns will not be converted as expected