Convert test_sql to pytest idiom
Should make onboarding the new ADBC drivers a little easier.

This can be done in a few phases/PRs

@jorisvandenbossche 
I think this is mergable. Plan is to keep getting rid of these classes in follow ups; let me know of any feedback Thanks @WillAyd 