more quoting identifiers

in ansisql.py, format_column(), any sqlalchemy.sql._ColumnClause falls into the "literal" case, and is not quoted.

The pu_a.dataC in the example IS such columnclause, and is not quoted, and PG complains. pu_a.dataB is not such a columnclause, and is quoted properly though.

Also see schema.py, the copy() and the make_proxy() are not consistent on case_sensitive arg. u could make the copy() more generic and use it on both places though.

SELECT pu_a.db_id AS pu_a_db_id, pu_a.name AS pu_a_name, pu_a.atype AS pu_a_atype, pu_a.dataC AS "pu_a_dataC", pu_a."dataB" AS "pu_a_dataB", pu_a."linkB_id" AS "pu_a_linkB_id", pu_a.linkC_id AS "pu_a_linkC_id" FROM ...

Comments (1)