Make use of materialized person columns in other insight features

[macobo]

Is your feature request related to a problem?

Person materialized columns are not always being used in all insights, instead an expensive subqueries are made for them.

Examples of this are Lifecycle, Stickiness, Retention insight features. Trends and funnels should work fine.

Describe the solution you'd like

Use materialized columns everywhere.

How to spot this in code: Look for calls to parse_prop_clauses without is_person_query or person_properties_column calls.

In those cases, use ColumnOptimizer to decide whether to join person table using ClickhousePersonQuery.

Describe alternatives you've considered

Additional context

Related: #5854

Thank you for your feature request – we love each and every one!

[macobo]

Stickiness added in #7117

Only lifecycle and sessions (deprecated) remain here + single events endpoint query

[posthog-bot]

This issue hasn't seen activity in two years! If you want to keep it open, post a comment or remove the stale label – otherwise this will be closed in two weeks.

[posthog-bot]

This issue was closed due to lack of activity. Feel free to reopen if it's still relevant.