Create table from existing pinot tables

Hi Pinot team, in a project I have few separated tables in Pinot and I am thinking to create a new Pinot table by just join them to save time and calculations.
It would be nice to have DDL capability to create table from xxx (a query).

Thank you!

No files, tests, or entry points are identified in the issue. Start by examining Pinot's existing DDL and query capabilities, then clarify the supported join and table-creation semantics before defining what a complete implementation and its tests should cover.

Written by the indexing model from the issue text.