API: update SQL functional api #6300
TST: test new read_sql api
Merge pull request #6867 from jorisvandenbossche/sql-api

API: update SQL functional api (GH6300)
BUG: TimeGrouper outputs different result by column order