public IColumnsListAggregation SubQuery(IStatementSelect select, string alias = "")
{
if (!string.IsNullOrEmpty(alias))
{
alias = " as " + SuperSql.FormatColumnAlias(alias);
}
this.Raw('(' + select.GetSql(false) + ')' + alias);
return(this);
}
public void FormatAliasColumn()
{
var alias = "text for alias";
SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
var result1 = SuperSql.FormatColumnAlias(alias);
Assert.Equal('\'' + alias + '\'', result1);
// SuperSql.DefaultFormatter = FormatterLibrary.MySql;
// var result2 = SuperSql.FormatColumnAlias(alias);
// Assert.Equal('\"' + alias + '\"', result2);
}
