using System;

using System.Collections.Generic;

using System.Linq;

​

using TSQL;

using TSQL.Clauses;

using TSQL.Elements;

using TSQL.Expressions;

using TSQL.Statements;

using TSQL.Tokens;

​

namespace TSQLParserExample

{

    public class Program

    {

        public static void Main(string[] args)

        {

            List<TSQLStatement> statements = TSQLStatementReader.ParseStatements(

                @"SELECT 1

                UNION

                SELECT 2

                UNION

                SELECT 3",

                includeWhitespace: false);

            Console.WriteLine(statements.Count);

            Console.WriteLine(statements.Single().AsSelect.Select.Columns.Single().Expression.AsConstant.Literal.AsNumericLiteral.Value.ToString());

            Console.WriteLine(statements.Single().AsSelect.SetOperators[0].Select.Select.Columns.Single().Expression.AsConstant.Literal.AsNumericLiteral.Value.ToString());

            Console.WriteLine(statements.Single().AsSelect.SetOperators[1].Select.Select.Columns.Single().Expression.AsConstant.Literal.AsNumericLiteral.Value.ToString());

        }

    }

}