sql格式化自动识别SQL语法结构

一、安装包

PoorMansTSqlFormatterLib

二、代码实现

using Microsoft.AspNetCore.Mvc;
using PoorMansTSqlFormatterLib.Formatters;
using PoorMansTSqlFormatterLib.Parsers;
using PoorMansTSqlFormatterLib.Tokenizers;

namespace SaaS.OfficialWebSite.Web.Controllers
{
    public class SqlFormatController : Controller
    {
        public IActionResult Index()
        {
            return View();
        }

        [HttpPost]
        public IActionResult FormatSql([FromBody] FormatRequest request)
        {
            try
            {
                var options = new TSqlStandardFormatterOptions
                {
                    IndentString = request.Options.IndentWithTabs ? "\t" : "    ",
                    SpacesPerTab = 4,
                    MaxLineWidth = 999,
                    KeywordStandardization = request.Options.UppercaseKeywords,
                    TrailingCommas = request.Options.TrailingCommas,
                    SpaceAfterExpandedComma = request.Options.SpaceAfterExpandedComma,
                    ExpandCommaLists = true,
                    ExpandBooleanExpressions = true,
                    ExpandCaseStatements = true,
                    ExpandBetweenConditions = true,
                    ExpandInLists = true,
                    BreakJoinOnSections = true,
                    UppercaseKeywords = request.Options.UppercaseKeywords
                };

                var tokenizer = new TSqlStandardTokenizer();
                var parser = new TSqlStandardParser();
                var formatter = new TSqlStandardFormatter(options);

                var tokenized = tokenizer.TokenizeSQL(request.Sql);
                var parsed = parser.ParseSQL(tokenized);
                var formattedSql = formatter.FormatSQLTree(parsed);

                return Ok(new { formattedSql });
            }
            catch (Exception ex)
            {
                return BadRequest(new { error = ex.Message });
            }
        }
    }

    public class FormatRequest
    {
        public string Sql { get; set; }
        public FormatOptions Options { get; set; }
    }

    public class FormatOptions
    {
        public bool IndentWithTabs { get; set; }
        public bool UppercaseKeywords { get; set; }
        public bool TrailingCommas { get; set; }
        public bool SpaceAfterExpandedComma { get; set; }
    }
}

运行效果：SQL 语句格式化