SQL: resolve legacy mode + deprecate mysql flavor (GH6900)

- removed warning for not using sqlalchemy (as sqlite DBAPI connection is fully supported, no warning needed)
- added deprecation warning for 'mysql' flavor
- removed necessity of providing flavor kwarg (no warning if not provided, assumed to be sqlite3)
- removed `flavor` kwarg from execute and read_sql_query (because a) are not database specific functions + b) would only be needed for mysql, but this will is deprecated so no need to introduce it)
- updated the tests to reflect this
- updated docs and docstrings to reflect that sqlite3 is the only but fully supported DBAPI connection (no 'legacy')
FIX sql handling of timedelta64 columns (GH6921)
Merge pull request #7077 from jorisvandenbossche/sql-legacy

SQL: resolve legacy mode + deprecate mysql flavor (GH6900)
Merge pull request #7076 from jorisvandenbossche/sql-timedelta

FIX sql handling of timedelta64 columns (GH6921)
TST: add tests for sql datetime writing

- not working for pymysql (skipping for now)
Merge pull request #7082 from jorisvandenbossche/sql-datetime

SQL: datetime writing: add tests + issue with pymysql
TST/CLN: centralize common validation methods in test_graphics
Merge pull request #7036 from sinhrks/cln_plottest

TST/CLN: centralize common validation methods in test_graphics
BUG: tz info lost by set_index and reindex