Versioning extension for SQLAlchemy.
I'm using the Identity object from SQLAlchemy to specify the default value of primary keys. ```python id: Mapped[int] = mapped_column( Integer, server_default=Identity(start=1, increment=1, always=True), primary_key=True, autoincrement=True, ) ``` I can successfully create all tables by using Base.metadata.create_all. However when I try to insert a record into one of the tables, I receive an error when it tries to insert into the version table: `ORA-32795: cannot insert into a generated always identity column` I can work around this by specifying `always=False` for the id column. (This is not ideal since I'd rather use `always=True` to express the intent that I never plan to manually set a value for the primary key.) Now I can insert records and records are also successfully inserted into the version tables. However, I still have a problem with Alembic. When I try using Alembic to autogenerate the revision for the tables I receive the following error: `sqlalchemy.exc.ArgumentError: A column with an Identity object cannot specify autoincrement=False` I'd appreciate any help anyone can offer. Python 3.12.0 SQLAlchemy 2.0.36 SQLAlchemy-Continuum 1.4.2 Alembic 1.13.3
This issue appears to be discussing a feature request or bug report related to the repository. Based on the content, it seems to be still under discussion. The issue was opened by duxnp and has received 0 comments.