public void TestAddSelectFields()
        {
            //-------------Setup Test Pack ------------------
            const string startSql = "select [FALSE FROM CLAUSE], [FALSE WHERE CLAUSE] from bob WHERE that = this";
            var          builder  = new SqlStatementBuilder(_connection, startSql);
            var          fields   = new List <string> {
                "myField1", "myField2"
            };
            const string expectedSql = "select [FALSE FROM CLAUSE], [FALSE WHERE CLAUSE], [myField1], [myField2] from bob WHERE that = this";

            //-------------Execute test ---------------------
            builder.AddSelectFields(fields);
            var actual = builder.GetStatement().Statement.ToString();

            //-------------Test Result ----------------------
            Assert.AreEqual(expectedSql, actual);
        }