COMPAT: infer_dtype not handling categoricals (GH8974)
Merge pull request #8975 from jreback/infer

COMPAT: infer_dtype not handling categoricals (GH8974)
ENH: Infer dtype from non-nulls when pushing to SQL

Minor cleanup

Minor rename

Simplifying