FIX: don't create 32 bit int type for int64 column (GH7433)

Closes #7433

Replace the sqlalchemy `Integer` type with `BigInteger` as the default integer type in pandas is int64. 
Probably we could be more specific in the type conversion (check for the exact integer type).