How to use

com.facebook.presto.sql.tree.AliasedRelation

constructor

public static Relation aliased(Relation relation, String alias, List<String> columnAliases)
{
  return new AliasedRelation(
      relation,
      identifier(alias),
      columnAliases.stream()
          .map(QueryUtil::identifier)
          .collect(Collectors.toList()));
}

@Override
public Node visitAliasedRelation(SqlBaseParser.AliasedRelationContext context)
{
  Relation child = (Relation) visit(context.relationPrimary());
  if (context.identifier() == null) {
    return child;
  }
  List<Identifier> aliases = null;
  if (context.columnAliases() != null) {
    aliases = visit(context.columnAliases().identifier(), Identifier.class);
  }
  return new AliasedRelation(getLocation(context), child, (Identifier) visit(context.identifier()), aliases);
}

Join.Type.IMPLICIT,
new Table(QualifiedName.of("t")),
new AliasedRelation(lateralRelation, identifier("a"), ImmutableList.of(identifier("x"))),
Optional.empty())));

@Test
public void testUnnest()
{
  assertStatement("SELECT * FROM t CROSS JOIN UNNEST(a)",
      simpleQuery(
          selectList(new AllColumns()),
          new Join(
              Join.Type.CROSS,
              new Table(QualifiedName.of("t")),
              new Unnest(ImmutableList.of(new Identifier("a")), false),
              Optional.empty())));
  assertStatement("SELECT * FROM t CROSS JOIN UNNEST(a, b) WITH ORDINALITY",
      simpleQuery(
          selectList(new AllColumns()),
          new Join(
              Join.Type.CROSS,
              new Table(QualifiedName.of("t")),
              new Unnest(ImmutableList.of(new Identifier("a"), new Identifier("b")), true),
              Optional.empty())));
  assertStatement("SELECT * FROM t FULL JOIN UNNEST(a) AS tmp (c) ON true",
      simpleQuery(
          selectList(new AllColumns()),
          new Join(
              Join.Type.FULL,
              new Table(QualifiedName.of("t")),
              new AliasedRelation(new Unnest(ImmutableList.of(new Identifier("a")), false), new Identifier("tmp"), ImmutableList.of(new Identifier("c"))),
              Optional.of(new JoinOn(BooleanLiteral.TRUE_LITERAL)))));
}

public static Relation aliased(Relation relation, String alias, List<String> columnAliases)
{
  return new AliasedRelation(relation, alias, columnAliases);
}

public static Relation aliased(Relation relation, String alias, List<String> columnAliases)
{
  return new AliasedRelation(
      relation,
      identifier(alias),
      columnAliases.stream()
          .map(QueryUtil::identifier)
          .collect(Collectors.toList()));
}

@Override
public Node visitAliasedRelation(SqlBaseParser.AliasedRelationContext context)
{
  Relation child = (Relation) visit(context.relationPrimary());
  if (context.identifier() == null) {
    return child;
  }
  return new AliasedRelation(getLocation(context), child, context.identifier().getText(), getColumnAliases(context.columnAliases()));
}

@Override
public Node visitAliasedRelation(SqlBaseParser.AliasedRelationContext context)
{
  Relation child = (Relation) visit(context.relationPrimary());
  if (context.identifier() == null) {
    return child;
  }
  List<Identifier> aliases = null;
  if (context.columnAliases() != null) {
    aliases = visit(context.columnAliases().identifier(), Identifier.class);
  }
  return new AliasedRelation(getLocation(context), child, (Identifier) visit(context.identifier()), aliases);
}

Join.Type.IMPLICIT,
new Table(QualifiedName.of("t")),
new AliasedRelation(lateralRelation, identifier("a"), ImmutableList.of(identifier("x"))),
Optional.empty())));

@Test
public void testUnnest()
{
  assertStatement("SELECT * FROM t CROSS JOIN UNNEST(a)",
      simpleQuery(
          selectList(new AllColumns()),
          new Join(
              Join.Type.CROSS,
              new Table(QualifiedName.of("t")),
              new Unnest(ImmutableList.of(new Identifier("a")), false),
              Optional.empty())));
  assertStatement("SELECT * FROM t CROSS JOIN UNNEST(a, b) WITH ORDINALITY",
      simpleQuery(
          selectList(new AllColumns()),
          new Join(
              Join.Type.CROSS,
              new Table(QualifiedName.of("t")),
              new Unnest(ImmutableList.of(new Identifier("a"), new Identifier("b")), true),
              Optional.empty())));
  assertStatement("SELECT * FROM t FULL JOIN UNNEST(a) AS tmp (c) ON true",
      simpleQuery(
          selectList(new AllColumns()),
          new Join(
              Join.Type.FULL,
              new Table(QualifiedName.of("t")),
              new AliasedRelation(new Unnest(ImmutableList.of(new Identifier("a")), false), new Identifier("tmp"), ImmutableList.of(new Identifier("c"))),
              Optional.of(new JoinOn(BooleanLiteral.TRUE_LITERAL)))));
}