ENH: dtype costumization on to_sql (GH8778)

This is the proposed general gist of the changes. My ad-hoc testing suggests that this might work. If this is an acceptible design, I will proceed to make the formal test and change the docs (including docstrings)

Closes #8778
Can you add here the a link to the issue? (see the other entries for the format)