Pyathena

* Support duration_seconds, poll_interval and kill_on_interrupt options in SQLAlchemy connection string.
Thanks acountrec. (214)
* Support passing the execute method keyword arguments to the pandas.read_csv method arguments.
Thanks bjcttam, austinlostinboston. (169, 210)

* Change the default value of `na_values` in PandasCursor from `None` to `empty character`.
If you want to change the behavior to that of the previous version, explicitly set `na_values` to `None` in the argument of the execute method.

import pyathena
from pyathena.pandas.cursor import PandasCursor
cursor = pyathena.connect(s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
region_name="us-west-2",
cursor_class=PandasCursor).cursor()
df = cursor.execute("SELECT * FROM many_rows",
na_values=None).as_pandas()

Thanks EdwardJRoss. (204)

* Support Multi-factor authentication.
https://github.com/laughingman7743/PyAthena#multi-factor-authentication
https://github.com/laughingman7743/PyAthena#assume-role-provider-with-mfa
* Implement cache expiration based on time.
Thanks rubenssoto. (187)

* Fix poll_interval type from int to float.
Thanks naikordian. (198)

* Fix extra package names to lowercase.
Thanks Akeboshiwind. (189)
* Support verify option in SQLAlchemy connection string.
Thanks tamersalama. (188)
* Implement DictCursor & AsyncDictCursor.
Thanks jerome-white. (194)

* Drop support for Python2.7 and Python3.5.
* Add type hints.
* Move the classes related to Pandas to the package `pyathena.pandas`.
* Remove the `execution_time_in_millis` field from the cursor and result set object. (Same as the `engine_execution_time_in_millis` field)