Sqlalchemy-redshift

------------------

- Import Iterable from collections.abc for Python 3.9 compatibility
(`Issue 189 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/189>`_)
- Add support for Parquet format in ``UNLOAD`` command
(`Issue 187 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/187>`_)

------------------

- Fix unhashable type error for sortkey reflection in SQLAlchemy >= 1.3.11
(`Issue 180 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/180>`_)
- Expose supported types for import from the dialect
(`Issue 181 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/181>`_)
- Reflect column comments
(`Issue 186 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/186>`_)

------------------

- Extend psycopg2 package version check to also support psycopg2-binary and psycopg2cffi
(`Issue 178 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/178>`_)

------------------

- Drop hard dependency on psycopg2 but require package to be present on runtime
(`Issue 165 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/165>`_)
- Switch from info to keyword arguments on columns for ``SQLAlchemy >= 1.3.0``
(`Issue 161 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/161>`_)
- Add support for column info on redshift late binding views
(`Issue 159 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/159>`_)
- Add support for ``MAXFILESIZE`` argument to ``UNLOAD``.
(`Issue 123 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/123>`_)
- Add support for the `CREATE LIBRARY`_ command.
(`Issue 124 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/124>`_)
- Add support for the `ALTER TABLE APPEND`_ command.
(`Issue 162 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/162>`_)
- Add support for the ``CSV`` format to `UnloadFromSelect`.
(`Issue 169 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/169>`_)
- Update the list of reserved words (adds "az64" and "language")
(`Issue 176 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/176>`_)

.. _CREATE LIBRARY: https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_LIBRARY.html
.. _ALTER TABLE APPEND: https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_TABLE_APPEND.html

------------------

- Add support for ``REGION`` argument to ``COPY`` and ``UNLOAD`` commands.
(`Issue 90 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/90>`_)

------------------

- Update tests to adapt to changes in Redshift and SQLAlchemy
(`Issue 140 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/140>`_)
- Add `header` option to `UnloadFromSelect` command
(`Issue 156 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/156>`_)
- Add support for Parquet and ORC file formats in the COPY command
(`Issue 151 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/150>`_)
- Add official support for Python 3.7
(`Issue 153 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/153>`_)
- Avoid manipulating search path in table metadata fetch by using system tables
directly (`Issue 147 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/147>`_)