Package io.prestosql.sql

Class QueryUtil

java.lang.Object

io.prestosql.sql.QueryUtil

public final class QueryUtil
extends Object

Method Summary

Modifier and Type	Method	Description
static Relation	aliased(Relation relation, String alias, List<String> columnAliases)
static SelectItem	aliasedName(String name, String alias)
static SelectItem	aliasedNullToEmpty(String column, String alias)
static SortItem	ascending(String name)
static Expression	caseWhen(Expression operand, Expression result)
static Expression	equal(Expression left, Expression right)
static Expression	functionCall(String name, Expression... arguments)
static Identifier	identifier(String name)
static Expression	logicalAnd(Expression left, Expression right)
static OrderBy	ordering(SortItem... items)
static Query	query(QueryBody body)
static Identifier	quotedIdentifier(String name)
static Row	row(Expression... values)
static Select	selectAll(List<SelectItem> items)
static Select	selectList(Expression... expressions)
static Select	selectList(SelectItem... items)
static Select	selectList(List<Expression> expressions)
static Query	simpleQuery(Select select)
static Query	simpleQuery(Select select, Relation from)
static Query	simpleQuery(Select select, Relation from, Expression where)
static Query	simpleQuery(Select select, Relation from, Expression where, OrderBy orderBy)
static Query	simpleQuery(Select select, Relation from, OrderBy orderBy)
static Query	simpleQuery(Select select, Relation from, Optional<Expression> where, Optional<GroupBy> groupBy, Optional<Expression> having, Optional<OrderBy> orderBy, Optional<Offset> offset, Optional<Node> limit)
static Query	simpleQuery(Select select, Relation from, Optional<Expression> where, Optional<OrderBy> orderBy)
static Query	singleValueQuery(String columnName, boolean value)
static Query	singleValueQuery(String columnName, String value)
static Relation	subquery(Query query)
static Table	table(QualifiedName name)
static SelectItem	unaliasedName(String name)
static Values	values(Row... row)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

identifier

public static Identifier identifier(String name)

quotedIdentifier

public static Identifier quotedIdentifier(String name)

unaliasedName

public static SelectItem unaliasedName(String name)

aliasedName

public static SelectItem aliasedName(String name,
                                     String alias)

selectList

public static Select selectList(Expression... expressions)

selectList

public static Select selectList(List<Expression> expressions)

selectList

public static Select selectList(SelectItem... items)

selectAll

public static Select selectAll(List<SelectItem> items)

table

public static Table table(QualifiedName name)

subquery

public static Relation subquery(Query query)

ascending

public static SortItem ascending(String name)

logicalAnd

public static Expression logicalAnd(Expression left,
                                    Expression right)

equal

public static Expression equal(Expression left,
                               Expression right)

caseWhen

public static Expression caseWhen(Expression operand,
                                  Expression result)

functionCall

public static Expression functionCall(String name,
                                      Expression... arguments)

values

public static Values values(Row... row)

row

public static Row row(Expression... values)

aliased

public static Relation aliased(Relation relation,
                               String alias,
                               List<String> columnAliases)

aliasedNullToEmpty

public static SelectItem aliasedNullToEmpty(String column,
                                            String alias)

ordering

public static OrderBy ordering(SortItem... items)

simpleQuery

public static Query simpleQuery(Select select)

simpleQuery

public static Query simpleQuery(Select select,
                                Relation from)

simpleQuery

public static Query simpleQuery(Select select,
                                Relation from,
                                OrderBy orderBy)

simpleQuery

public static Query simpleQuery(Select select,
                                Relation from,
                                Expression where)

simpleQuery

public static Query simpleQuery(Select select,
                                Relation from,
                                Expression where,
                                OrderBy orderBy)

simpleQuery

public static Query simpleQuery(Select select,
                                Relation from,
                                Optional<Expression> where,
                                Optional<OrderBy> orderBy)

simpleQuery

public static Query simpleQuery(Select select,
                                Relation from,
                                Optional<Expression> where,
                                Optional<GroupBy> groupBy,
                                Optional<Expression> having,
                                Optional<OrderBy> orderBy,
                                Optional<Offset> offset,
                                Optional<Node> limit)

singleValueQuery

public static Query singleValueQuery(String columnName,
                                     String value)

singleValueQuery

public static Query singleValueQuery(String columnName,
                                     boolean value)

query

public static Query query(QueryBody body)