Ah! I figured it out, it's in SqlDialect, by default `hasImplicitTableAlias` is set to true. I just need to override to false
https://github.com/apache/calcite/blob/79879f92abc4f2279496a0e6ca9066d9d24a1457/core/src/main/java/org/apache/calcite/rel/rel2sql/SqlImplementor.java#L1758-L1759 On Tue, Feb 14, 2023 at 7:31 PM Guillaume Masse < [email protected]> wrote: > Hi, > > I would like to know if there is a way to keep identifiers fully > qualified, for example: > > sql = parse("SELECT t1.field FROM t1") > rel = sql2rel(sql) > sql2 = rel2sql(rel) > > sql2 obtained: > "SELECT field FROM t1" > > expected: > "SELECT t1.field FROM t1" > > If I'm working on a join query, identifiers are kept. > > Thanks, > Guillaume >
