Truncate table option for to sql
- [X] closes #37210 - in order to reload a table but not drop it to avoid CASCADE-ing
- [X] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [X] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [X] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [X] Added an entry in the latest `doc/source/whatsnew/v1.5.3.rst` file if fixing a bug or adding a new feature.

This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this. Thanks for the pull request, but it appears to have gone stale. If interested in continuing, please merge in the main branch, address any review comments and/or failing tests, and we can reopen. What else needs to be done to get truncate into pandas ? > What else needs to be done to get truncate into pandas ?

Not 100% sure - this is my first ever PR attempt for an open source project. I think the code is good to go but let it go stale (apologies) when things got busy. At the very least I'll need to solve for some conflicts and update the `whats_new` to a future version. 

I'll start working on it again but if you're willing, I could certainly use some help/guidance in getting it over the finish line.