Add possibility of using properties of objects within a list property in insights

Is your feature request related to a problem?

I am sending a list of products represented as objects inside the order property. Currently, I cannot access any of the individual fields of each order to use it as a filter or as a break down.

Some simple thing like contains within products work, but doing anything more advanced like aggregations or calculations on 3rd level of properties does not seem to be supported.

Describe the solution you'd like

Have a new type of properties: list and object, that would allow me to select the filter as follows:

• Event: order placed
• Property: products
• List object property: product_name

Describe alternatives you've considered

• Using HogSQL does not work for me with properties.products.product_name = 'hog'
• Flattening a schema or using HogSQL

Additional context

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

The issue names no files, tests, or entry points. First clarify the intended semantics for nested list and object properties in filters, breakdowns, aggregations, and calculations, then identify the relevant insights implementation and tests; done means those use cases are supported with coverage.