Support `IDENTITY` instead of serial columns

[zachdaniel]

Instead of the bigserial type, we should use GENERATED BY DEFAULT AS IDENTITY. For more information, see here: https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_serial

We can put this behind an opt-in configuration until the next major release.