Upload with oem2orm dtype `int` is interpreted as `bigint`

[chrwm]

Using this tutorial and this metadata yields the table below on the OEP

Upload with example_df.to_sql(table_name, connection, schema=schema, if_exists='append', index=False) yields the error:

Out of range float values are not JSON compliant
Writing to umas_potentials failed!

and no data will be uploaded.

However, when I use https://modex.rl-institut.de/create_table/ to create and upload the table, this yields

and upload works fine.

The columns id and id_scal both contain integer values.

Final table: https://openenergy-platform.org/dataedit/view/model_draft/umas_potentials