BUG: error raise when column contains percentage
- [x] closes #37157 
- [x] tests added / passed
- [x] passes `black pandas`
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] whatsnew entry

This pull request is stale because it has been open for thirty days with no activity. Please update or respond to this comment if you're still interested in working on this. > lgtm but needs to be looked over by someone who's more familiar with the sql module
> 
> @erfannariman would you mind merging master again to make sure this up to date

Done this was deliberately changed in this was deliberately changed in #34212 so not sure why you think this is a regression. thanks @erfannariman  @meeseeksdev backport 1.2.x