public static SelectExpressionToken PlainSelect(
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return
(new SelectExpressionToken(
select,
from,
where.ToOption(),
groupBy.ToOption(),
orderBy.ToOption()));
}
public static SelectExpressionToken PlainSelect(
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null,
LimitOffsetNode limitOffset = null)
{
return
(new SelectExpressionToken(
select,
from,
where.ToOption(),
groupBy.ToOption(),
orderBy.ToOption(),
limitOffset ?? new LimitOffsetNode(FSharpOption <int> .None, FSharpOption <int> .None)));
}
public static AST.ICommonTableDefinition TableDef <TType>(
TableIdentifier <TType> tdef,
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null,
LimitOffsetNode limitOffset = null)
{
return
(new AST.CommonTableDefinition <TType>(
PlainSelectExpression.NewPlain(
new SelectExpressionToken(
select,
from,
where.ToOption(),
groupBy.ToOption(),
orderBy.ToOption(),
limitOffset ?? new LimitOffsetNode(FSharpOption <int> .None, FSharpOption <int> .None))),
tdef));
}