CQL return pages or content, etc, that match certain criteria

I was thinking it would be really cool if you guys added CQL. Essentially a query language that returns pages or attributes from pages that meet certain criteria.

You could match on labels, creation time, space, attachments, whether it has children, etc.

You could match on some of the attributes here:
https://developer.atlassian.com/static/javadoc/confluence/latest/reference/com/atlassian/confluence/pages/Page.html

I ran into the need when I wanted to include all of the pages of the children of a parent. However there were so many it would be very tedious to do so with page includes. I started writing a macro for it, but I don't think we should need to make our own macros to do something so simple.

Even that however was a workaround for what I really needed.

What I really needed was to include the content of all children of a certain parents who matched a certain creation date.