Pyathena

* Add `row_format`, `file_format`, `serdeproperties` and `tblproperties` to dialect options in SQLAlchemy 306
* Support for creating tables in various file and row formats in SQLAlchemy.
https://github.com/laughingman7743/PyAthena#dialect-options
* Support for creating tables in various file and row formats is also available in the pandas.DataFrame.to_sql.
https://github.com/laughingman7743/PyAthena#to-sql
* The `s3_dir` option in the connection string has been removed and is now specified in the `location` of the dialect option.
* Remove `AthenaRowFormat` model class.
* Add `AthenaFileFormat` and `AthenaRowFormatSerde` model classes

* Fix escape handling for insert statements containing single quotes 304
Thanks bertop89 238
* Support for partition columns in SQLAlchemy 305

* 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