C# .NET Core ???? SQL ??? ?? ????? ?? ??? ????? ?? ??? ???? ???? ???? ???. ? ????? ??? ??? ??? ???? ?? ???? ??? ?????.

Microsoft SQL Parser? ???? Transact-SQL(T-SQL) ?? ??

Transact-SQL(T-SQL)? ?? Microsoft? Microsoft.SqlServer.Management.SqlParser.dll??? ?? ????? ?????. ? ?????? SQL ??? ???? ?? ??? ? ?? Microsoft.SqlServer.Management.SqlParser.Parser ??????? ???? ????.

?? ?? ??? ? ??? ???? T-SQL ???? ???? ?? ???? ??? ?????.

IEnumerable<TokenInfo> ParseSql(string sql)
{
    var parseOptions = new ParseOptions();
    var scanner = new Scanner(parseOptions);

    int state = 0, start, end, lastTokenEnd = -1, token;
    bool isPairMatch, isExecAutoParamHelp;

    var tokens = new List<TokenInfo>();

    scanner.SetSource(sql, 0);

    while ((token = scanner.GetNext(ref state, out start, out end, out isPairMatch, out isExecAutoParamHelp)) != (int)Tokens.EOF)
    {
        var tokenInfo = new TokenInfo
        {
            Start = start,
            End = end,
            IsPairMatch = isPairMatch,
            IsExecAutoParamHelp = isExecAutoParamHelp,
            Sql = sql.Substring(start, end - start + 1),
            Token = (Tokens)token,
        };

        tokens.Add(tokenInfo);
        lastTokenEnd = end;
    }

    return tokens;
}

TokenInfo ???? ?? ? ? ??, ??? ??, ?? SQL ???? ???? ?? ??? ??? ?? ??? ??????. Tokens ????? TOKEN_BEGIN, TOKEN_COMMIT, TOKEN_EXISTS ? ??? ?? ??? ???? ?? ?? ???? ????.

?? ??

Microsoft SQL Parser? ??? ?? ??? ???? ??? ?? ??? ????? ?? ?? ??? ??? ???? ??? ??? ???? ?? ??? ? ????. ???? ??? ????? ??? ??? ????? ??? ??? ??? ? ???? ? ????. ?? ??? ??(?: ANTLR ?? Bison)? ?? ??? ???? ??? ??? ???? ??? ???? ???? ???? ??? ?????.

???? ?? ??? ????? SQL ?? ?? ??? ?? ?? ??? ???? ?? ?????. Microsoft SQL Parser? ???? T-SQL? ?? ????? ?? ?? ??? ?? ?? ??? ?????? SQL ??? ?? ??? ????? ????? ?? ??? ??? ? ????.

? ??? .NET Core? ???? C#?? SQL ??? ??? ?? ??? ? ????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!