Fix type hints for to_dict and from_dict

[KianShah]

Seems like when the 'tight' option for the 'orient' parameter was added, the type hints were not updated (nor were the exception messages).

Related to:
pandas-dev/pandas#47450

[mdespriee]

'record' in to_dict() is missing as well

[Dr-Irv]

fixed in #39