Incompatibility with newer pandas versions

[khelfer]

In pandas 1.5, the parameter line_terminator of the to_csv function was renamed to lineterminator (see here). This seems to break bcpy as the following error message shows:

  File "...\bcpy\data_objects.py", line 315, in to_sql
    self._df.to_csv(
TypeError: NDFrame.to_csv() got an unexpected keyword argument 'line_terminator'

Using pandas 1.4.4 (or 1.5.3 if you don't mind the FutureWarning) is a workaround, but it would be great if current versions (2.0+) of pandas could be supported too.