Is there a auto-increment flag?

[Abhinav-676]

Hello, I hope you guys are doing great.

I wanted to know, if the auto-increment flag for columns in supported, and if yes that how we can do it.

Is it something to do with the "defaultSql" parameter?
For Example:
export const usersTable = t("users", { id: c("bigint", {primaryKey: true, defaultSql: "GENERATED ALWAYS AS IDENTITY"}), })

[IzumiSy]

Currently, Kyrage does not expose auto-increment API, but I will add the feature. Just a moment.

[Abhinav-676]

Hii, sorry for my ignorance.

I think we can do this with setting the type to "bigserial".

[IzumiSy]

I think we can do this with setting the type to "bigserial".

Wow, I didn't know that.

I guess "bigserial" is enough for PSQL, but Kyrage is going to support other SQL compatible databases like MySQL, so auto-increment API would still be useful for people who use them.