public UpdateDestinationTable(string name)
        {
            var f = UpdateDestinationTable.Parse(name);

            _table  = f._table;
            _column = f._column;
            _alias  = f._alias;
        }
        public static UpdateDestinationTable Parse(string sqlStatement)
        {
            var field = new UpdateDestinationTable();

            if (sqlStatement == null)
            {
                throw new ArgumentNullException(nameof(sqlStatement));
            }

            sqlStatement = sqlStatement.ClearString();

            if (sqlStatement.StartsWith("only", StringComparison.OrdinalIgnoreCase))
            {
                field._includeDescendants = false;
                sqlStatement = sqlStatement.Substring(4).ClearString();
            }
            else
            {
                field._includeDescendants = true;
            }

            if (sqlStatement.EndsWith(" AS", StringComparison.OrdinalIgnoreCase))
            {
                sqlStatement = sqlStatement.Substring(0, sqlStatement.Length - 3);
            }
            var indexOfAs = sqlStatement.ToUpper().IndexOf(" AS ", StringComparison.OrdinalIgnoreCase);

            if (indexOfAs > 0)
            {
                field._alias = sqlStatement.Substring(indexOfAs + 4).ClearString();
                sqlStatement = sqlStatement.Substring(0, indexOfAs).ClearString();
            }

            if (sqlStatement.Contains("."))
            {
                var arr = sqlStatement.Split('.');
                field._table = arr[0].ClearString();
                sqlStatement = arr[1].ClearString();
            }

            if (sqlStatement == "*")
            {
                field._alias = null;
            }

            field._column = sqlStatement;

            return(field);
        }