Can greptime support the same name column before statement_to_plan?

[yihong0618]

What type of enhancement is this?

User experience

What does the enhancement do?

for now seems greptime do not support same name column for the select stmt
very simple query will raise error

select 1,1;
--  Failed to plan SQL: Error during planning: Projections require unique expression names but the expression "Int64(1)" at position 0 and "Int64(1)" at position 1 have the same name. Consider aliasing ("AS") one of them.

and it seems from this line

greptimedb/src/query/src/planner.rs

Line 106 in f069ea0

.statement_to_plan(df_stmt)

datafusion side raise this error;

but for pg user(maybe others) it is a very common use case like

select oid, * from xxxx;

my question is that can we support that? I did some search like risingwave and databend seems support it. but I tried it kind of hard for me for support it myself, so I left this issue here.

and this feature also block some IDE like DBeaver support

@sunng87

Implementation challenges

No response