Package io.prestosql.sql
Class QueryUtil
- java.lang.Object
-
- io.prestosql.sql.QueryUtil
-
public final class QueryUtil extends java.lang.Object
-
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static Relationaliased(Relation relation, java.lang.String alias, java.util.List<java.lang.String> columnAliases)static SelectItemaliasedName(java.lang.String name, java.lang.String alias)static SelectItemaliasedNullToEmpty(java.lang.String column, java.lang.String alias)static SortItemascending(java.lang.String name)static ExpressioncaseWhen(Expression operand, Expression result)static Expressionequal(Expression left, Expression right)static ExpressionfunctionCall(java.lang.String name, Expression... arguments)static Identifieridentifier(java.lang.String name)static ExpressionlogicalAnd(Expression left, Expression right)static OrderByordering(SortItem... items)static Queryquery(QueryBody body)static IdentifierquotedIdentifier(java.lang.String name)static Rowrow(Expression... values)static SelectselectAll(java.util.List<SelectItem> items)static SelectselectList(Expression... expressions)static SelectselectList(SelectItem... items)static SelectselectList(java.util.List<Expression> expressions)static QuerysimpleQuery(Select select)static QuerysimpleQuery(Select select, Relation from)static QuerysimpleQuery(Select select, Relation from, Expression where)static QuerysimpleQuery(Select select, Relation from, Expression where, OrderBy orderBy)static QuerysimpleQuery(Select select, Relation from, OrderBy orderBy)static QuerysimpleQuery(Select select, Relation from, java.util.Optional<Expression> where, java.util.Optional<GroupBy> groupBy, java.util.Optional<Expression> having, java.util.Optional<OrderBy> orderBy, java.util.Optional<Offset> offset, java.util.Optional<Node> limit)static QuerysimpleQuery(Select select, Relation from, java.util.Optional<Expression> where, java.util.Optional<OrderBy> orderBy)static QuerysingleValueQuery(java.lang.String columnName, boolean value)static QuerysingleValueQuery(java.lang.String columnName, java.lang.String value)static Relationsubquery(Query query)static Tabletable(QualifiedName name)static SelectItemunaliasedName(java.lang.String name)static Valuesvalues(Row... row)
-
-
-
Method Detail
-
identifier
public static Identifier identifier(java.lang.String name)
-
quotedIdentifier
public static Identifier quotedIdentifier(java.lang.String name)
-
unaliasedName
public static SelectItem unaliasedName(java.lang.String name)
-
aliasedName
public static SelectItem aliasedName(java.lang.String name, java.lang.String alias)
-
selectList
public static Select selectList(Expression... expressions)
-
selectList
public static Select selectList(java.util.List<Expression> expressions)
-
selectList
public static Select selectList(SelectItem... items)
-
selectAll
public static Select selectAll(java.util.List<SelectItem> items)
-
table
public static Table table(QualifiedName name)
-
ascending
public static SortItem ascending(java.lang.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(java.lang.String name, Expression... arguments)
-
row
public static Row row(Expression... values)
-
aliased
public static Relation aliased(Relation relation, java.lang.String alias, java.util.List<java.lang.String> columnAliases)
-
aliasedNullToEmpty
public static SelectItem aliasedNullToEmpty(java.lang.String column, java.lang.String alias)
-
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, java.util.Optional<Expression> where, java.util.Optional<OrderBy> orderBy)
-
simpleQuery
public static Query simpleQuery(Select select, Relation from, java.util.Optional<Expression> where, java.util.Optional<GroupBy> groupBy, java.util.Optional<Expression> having, java.util.Optional<OrderBy> orderBy, java.util.Optional<Offset> offset, java.util.Optional<Node> limit)
-
singleValueQuery
public static Query singleValueQuery(java.lang.String columnName, java.lang.String value)
-
singleValueQuery
public static Query singleValueQuery(java.lang.String columnName, boolean value)
-
-