Skip to content

Generate Select * for queries when applicable for shorter SQL #21320

@smitpatel

Description

@smitpatel

Currently we project all the columns from a table in the projection. We can project SELECT t.* for generate shorter SQL.
Notes to implementer:

  • Best place to do would be SQL Gen. Method GenerateProjection. We can detect that all the projection expressions are column expression and coming from same table then we can use table.* directly.
  • Overriding method will allow provider to change the "optimization". e.g. postgres does not project "xmin" column out of the table, SELECT * in such cases, need to list all the columns.

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions