Review missing ID autoincrement for sqlite

[tcompa]

As part of #1934, we need dataset IDs to be unique, even if a dataset is removed.
@ychiucco wrote a test for it (in #1990), which is OK on postgres but fails on sqlite.

Relevant refs:

• https://docs.sqlalchemy.org/en/20/dialects/sqlite.html#using-the-autoincrement-keyword
• https://sqlite.org/autoinc.html

[tcompa]

Refs

• https://docs.sqlalchemy.org/en/20/core/metadata.html#sqlalchemy.schema.Column.params.autoincrement
• How to have a AUTO_INCREMENT field different from primary_key fastapi/sqlmodel#1012

[ychiucco]

We've tried

class DatasetV2(SQLModel, table=True):

    id: Optional[int] = Field(
        default=None,
        primary_key=True,
        sa_column_kwargs={'autoincrement': True}
    )

but nothing changed

[tcompa]

Also see #1260

[tcompa]

Closed with #1990