SQL: How to parse Microsoft Transact-SQL Statements in C# and to match the column aliases of a view

本文介绍了一个使用C#解析Microsoft Transact-SQL (T-SQL) 语句的方法，并提供了一个公共静态方法TSqlScriptConvert，该方法接收SQL字符串并返回格式化的SQL语句。此外还展示了如何设置解析选项，例如关键字大小写、多行选择元素等。

转载：https://www.andriescu.nl/sql/sql-how-to-parse-microsoft-transact-sql-statements-in-c_sharp_view_column_binding/

public static TSqlScript Convert(string sql, out string prettySql)
{
    var hasQuotedIdentifiers = false;
    var parser = new TSql100Parser(hasQuotedIdentifiers);
    var options = new SqlScriptGeneratorOptions();
    options.SqlVersion = SqlVersion.Sql100;
    options.KeywordCasing = KeywordCasing.Uppercase;
    options.MultilineSelectElementsList = true;
    options.MultilineWherePredicatesList = true;
 
    IScriptFragment fragment;
    IList<ParseError> errors;
    using (var sr = new StringReader(sql))
    {
        fragment = parser.Parse(sr, out errors);
    }
 
    if (errors != null && errors.Count > 0)
    {
        var errorMessage = new StringBuilder();
        foreach (var error in errors)
        {
            errorMessage.Append(error.Message);
            errorMessage.Append("offset " + error.Offset);
        }
 
        throw new ApplicationException(errorMessage.ToString());
    }
 
    new Sql100ScriptGenerator(options).GenerateScript(fragment, out prettySql);
 
    var parsedSql = fragment as TSqlScript;
 
    return parsedSql;
}