Support Asterisks and Qualified Asterisks for Multiple Joins Without Subqueries #4898 (artem Zuikov)

Why it matters

This feature simplifies query writing when performing multiple table joins by allowing users to select all columns from one or more tables using asterisks or qualified asterisks directly in the SELECT clause. It resolves the inconvenience of rewriting subqueries just to avoid column ambiguity in multi-join scenarios.

How to use it

Users can now write queries with multiple JOIN operations and use either plain asterisks () to select all columns or qualified asterisks like table. without wrapping the joins in subqueries. For example:

SELECT  FROM table1
JOIN table2 ON table1.id = table2.id
JOIN table3 ON table2.id = table3.id

or

SELECT table1., table2.* FROM table1
JOIN table2 ON table1.id = table2.id

This new support makes query clauses clearer and more concise.