feat(performance): query improvements for trends (load less people) #88137

feat(performance): query improvements for trends (load less people)

Usage Workflow file

10 errors and 2 warnings

"SelectQuery" has no attribute "optimize_aggregation_in_order"

Item "None" of "SelectQueryType | None" has no attribute "ctes"

Item "None" of "SelectQueryType | None" has no attribute "ctes"

List item 1 has incompatible type "AST"; expected "Expr"

Incompatible types in assignment (expression has type "AST", variable has type "Expr | None")

"SelectQuery" has no attribute "optimize_aggregation_in_order"

Item "HogQLQuery" of "InsightActorsQuery | FunnelsActorsQuery | FunnelCorrelationActorsQuery | HogQLQuery" has no attribute "source"

Argument 1 to "capture_queries" of "ClickhouseTestMixin" has incompatible type "Callable[[str], Match[str] | None]"; expected "Callable[[str], bool]"

Incompatible return value type (got "Match[str] | None", expected "bool")

Argument 1 to "capture_queries" of "ClickhouseTestMixin" has incompatible type "Callable[[str], Match[str] | None]"; expected "Callable[[str], bool]"

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following artifacts were uploaded using a version of actions/upload-artifact that is scheduled for deprecation: "email_renders". Please update your workflow to use v4 of the artifact actions. Learn more: https://github.blog/changelog/2024-04-16-deprecation-notice-v3-of-the-artifact-actions/