public Builder WITH(SqlId alias, Builder subQuery)
{
return this.WITH("{0} AS ({1})", alias, subQuery);
}
public Builder UPDATE(SqlId id)
{
return this.UPDATE("{0}", id);
}
public Builder UPDATE(Builder subQuery)
{
var withAlias = new SqlId("subQuery");
return this.WITH(withAlias, subQuery).UPDATE(withAlias);
}
public Builder FROM(SqlId alias, Builder subQuery)
{
return this.FROM("({0}) {1}", subQuery, alias);
}
public Builder SET(SqlId id, object value)
{
return this.SET("{0} = {1}", id, value);
}
public Builder DELETE_FROM(SqlId id)
{
return this.DELETE_FROM("{0}", id);
}
public Builder DELETE_FROM(Builder subQuery)
{
var withAlias = new SqlId("subQuery");
return this.WITH(withAlias, subQuery).DELETE_FROM(withAlias);
}
public Builder UPDATE(Builder subQuery)
{
var withAlias = new SqlId("subQuery");
return(this.WITH(withAlias, subQuery).UPDATE(withAlias));
}
public Builder SET(SqlId id, object value)
{
return(this.SET("{0} = {1}", id, value));
}
public Builder UPDATE(SqlId id)
{
return(this.UPDATE("{0}", id));
}
public Builder DELETE_FROM(Builder subQuery)
{
var withAlias = new SqlId("subQuery");
return(this.WITH(withAlias, subQuery).DELETE_FROM(withAlias));
}
public Builder DELETE_FROM(SqlId id)
{
return(this.DELETE_FROM("{0}", id));
}
public Builder FROM(SqlId alias, Builder subQuery)
{
return(this.FROM("({0}) {1}", subQuery, alias));
}
public Builder WITH(SqlId alias, Builder subQuery)
{
return(this.WITH("{0} AS ({1})", alias, subQuery));
}