def test_annotate_fromlist_preservation(self):
        table1 = table('table1', column('x'))
        table2 = table('table2', column('y'))
        a1 = table1.alias()
        s = select([a1.c.x]).select_from(
            a1.join(table2, a1.c.x == table2.c.y)
        )

        assert_s = select([select([s])])
        for fn in (
            sql_util._deep_deannotate,
            lambda s: sql_util._deep_annotate(s, {'foo': 'bar'}),
            lambda s: visitors.cloned_traverse(s, {}, {}),
            lambda s: visitors.replacement_traverse(s, {}, lambda x: None)
        ):

            sel = fn(select([fn(select([fn(s)]))]))
            eq_(str(assert_s), str(sel))
Gets a file system friendly name from the catalog dataset name
dataset/ETHPy150Open zzzeek/sqlalchemy/test/sql/test_selectable.py/AnnotationsTest.test_annotate_fromlist_preservation--crossover with--dataset/ETHPy150Open opencolorado/OpenColorado-Tools-and-Utilities/Scripts/ArcGIS/10.0/Python/PublishOpenDataset.py/get_dataset_filename