SQL: add multi-index support to legacy mode (#6881)

and at once also index_label kwarg support
SQL: keep backwards compatibility for write_frame index handling
Merge pull request #6883 from jorisvandenbossche/sql-multiindex

SQL: add multi-index support to legacy mode