Hello! With the release of 0.12.0, is the README section for https://github.com/apache/pinot#when-should-i-use-pinot still valid? In terms of the join support.

Pinot is not a replacement for database i.e it cannot be used as source of truth store, cannot mutate data. While Pinot supports text search, it's not a replacement for a search engine. Also, Pinot queries cannot span across multiple tables by default. You can use the Trino-Pinot Connector or Presto-Pinot Connector to achieve table joins and other features.

It would depend on the complexity of the joins. I can see it work for some scenarios perhaps not all.

We would need to update the doc wirh availablity of upserts and joins. cc @Matthew Helmke

Thanks @Mayank!