public AnsiSelectBuilder filter(final WhereClause whereClause) {
return from(
grammar,
selectExpression(
expression.setQuantifier(),
expression.selectList(),
expression.fromClause(),
some(combine(expression.whereClause(), whereClause)),
expression.orderByClause(),
expression.groupByClause(),
expression.offsetClause(),
expression.fetchClause()));
}
public AnsiSelectBuilder orderBy(final OrderByClause orderByClause) {
return from(
grammar,
selectExpression(
expression.setQuantifier(),
expression.selectList(),
expression.fromClause(),
expression.whereClause(),
some(orderByClause),
expression.groupByClause(),
expression.offsetClause(),
expression.fetchClause()));
}
@Override
public AnsiSelectBuilder distinct() {
return from(
grammar,
selectExpression(
Option.<SetQuantifier>some(DISTINCT),
expression.selectList(),
expression.fromClause(),
expression.whereClause(),
expression.orderByClause(),
expression.groupByClause(),
expression.offsetClause(),
expression.fetchClause()));
}
@Override
public AnsiSelectBuilder fetch(int number) {
return from(
grammar,
selectExpression(
expression.setQuantifier(),
expression.selectList(),
expression.fromClause(),
expression.whereClause(),
expression.orderByClause(),
expression.groupByClause(),
expression.offsetClause(),
some(grammar.fetchClause(number))));
}
@Override
public Sequence<Keyword<?>> fields() {
return SelectList.methods.fields(expression.selectList());
}
