kysely-org / kysely

A type-safe typescript SQL query builder
https://kysely.dev
MIT License
9.9k stars 249 forks source link

Alter sequence with builder? #935

Closed CzechCoder closed 3 months ago

CzechCoder commented 3 months ago

I'm trying to execute "ALTER SEQUENCE order_number INCREMENT BY 1000" and no luck with finding how to do that.

Is there any good way to apply it to a column that I set up like this? I'd like to shift the count 1000 ahead so it's not the same as the row's id.

.addColumn('order_number', 'bigserial', (col) => col.notNull())