[Sqlalchemy-tickets] Issue #4197: quoting for CTE names (zzzeek/sqlalchemy)

[Michael B. <iss...@bi...>]

New issue 4197: quoting for CTE names
https://bitbucket.org/zzzeek/sqlalchemy/issues/4197/quoting-for-cte-names

Michael Bayer:

```
#!python

 def test_named_alias_no_quote(self):
        cte = select([literal(1).label("id")]).cte(name='CTE')

        s1 = select([cte.c.id]).alias(name="no_quotes")

        s = select([s1])
        self.assert_compile(
            s,
            'WITH "CTE" AS (SELECT :param_1 AS id) '
            'SELECT no_quotes.id FROM '
            '(SELECT "CTE".id AS id FROM "CTE") AS no_quotes'
        )

    def test_named_alias_quote(self):
        cte = select([literal(1).label("id")]).cte(name='CTE')

        s1 = select([cte.c.id]).alias(name="Quotes Required")

        s = select([s1])
        self.assert_compile(
            s,
            'WITH "CTE" AS (SELECT :param_1 AS id) '
            'SELECT "Quotes Required".id FROM '
            '(SELECT "CTE".id AS id FROM "CTE") AS "Quotes Required"'
        )
```