feat: serial (autoincrement) column type

[matrixise]

Problem / use case

This feature would be really interesting when you want to fill a table that would act as a history for actions. Without it, you have to play with composite keys and sometimes it just doesn't work.

Proposed solution

Use the serial column from Drizzle

[typedarray]

Thanks for opening - just noting that we definitely want to add this, but it's not as easy as just adding the Drizzle serial column type. Our in-memory store and batched write mechanism makes this more complex to implement.

[matrixise]

I haven't looked at the code, but isn't it possible to make an exception in the case of PostgreSQL?

Thanks