@staticmethod
    def test_with_query():
        query = ('WITH data AS (SELECT x, y FROM xy) SELECT x,y FROM data')

        columns = parse_select_columns(query)
        eq_(columns, ['x', 'y'])
Basic test for select statement with the with query
dataset/ETHPy150Open coursera/dataduct/dataduct/database/parsers/tests/test_select_query.py/TestCreateTableStatement.test_with_query