Pyathena

* Use new style classes 300
* Remove next method for compatibility with Python2 300
* Add missing type hints 301
* Support for compressed fields of table metadata in various data formats 302
* Add public method for metadata retrieval to cursor class 303

* Add missing partition key columns to get_columns in SQLAlchemy 293
Thanks nananathanh 292

* Fix CAST from STRING to VARCHAR for string types with unspecified length in SQLAlchemy 291
Thanks luca-ferreri andreaschiappacasse 289

* Add support for table and column comments in SQLAlchemy 264
Thanks cansjt 263
* Change partition repair in to_sql to ALTER TABLE ADD PARTITION instead of MSCK REPAIR TABLE 274 282
Thanks Liam3851 246, bajram-hushi 276
* Add AthenaPandas dialect 271
https://github.com/laughingman7743/PyAthena#dialect--driver
* Fix the syntax for combining the OFFSET and LIMIT clauses in SQLAlchemy 283
Thanks gruuya 280
* Remove table constraints from CREATE TABLE statements in SQLAlchemy 281
Thanks terrylimnsv 279
* Change to use INT as the column type for Integer type in SQLAlchemy DDL 281
Thanks terrylimnsv 279
* If length is not specified in VARCHAR, use the STRING type in SQLAlchemy 286
Thanks terrylimnsv 279
* Support VARCHAR type length in SQLAlchemy types 286
* Support DECIMAL type precision and scale in SQLAlchemy types 286
* Change metadata retrieval from information schema to API in SQLAlchemy 286
* Support for the If_not_exists option in SQLAlchemy 281
* Use to_dict instead of Iterrows in PandasCursor 284
Thanks avibrazil 254

- Fix to not include views when getting table names in SQLAlchemy.
- Support getting view names in SQLAlchemy
Thanks aaronsteers, cansjt. (244)

* Drop support for Python 3.6.
* Support for Python 3.10.
* Add base dialect definition `awsathena`, independent of driver notation.
* Add support for setting table location and compression in [dialect options](https://docs.sqlalchemy.org/en/14/core/foundation.html#sqlalchemy.sql.base.DialectKWArgs.dialect_options).
Thanks cansjt. (258)