@testing.crashes('oracle', 'FIXME: unknown, verify not fails_on')
    @testing.requires.subqueries
    def test_labels(self):

        self.assert_compile(
            table1.select(distinct=True).alias('LaLa').select(),
            'SELECT '
            '"LaLa".lowercase, '
            '"LaLa"."UPPERCASE", '
            '"LaLa"."MixedCase", '
            '"LaLa"."ASC" '
            'FROM ('
            'SELECT DISTINCT '
            '"WorstCase1".lowercase AS lowercase, '
            '"WorstCase1"."UPPERCASE" AS "UPPERCASE", '
            '"WorstCase1"."MixedCase" AS "MixedCase", '
            '"WorstCase1"."ASC" AS "ASC" '
            'FROM "WorstCase1"'
            ') AS "LaLa"'
        )
test the quoting of labels.
dataset/ETHPy150Open zzzeek/sqlalchemy/test/sql/test_quote.py/QuoteTest.test_labels