How to run parametrized raw SQL in Kysely?

I know I can run a raw sql with:

Kysely ColumnType Insert Type Compilation Error

I used kysely-codegen and it spit out something like the following:

how to set minimum to auto increment using kysely?

I want to translate below code to kysely, but I can’t figure out how to set minimum to auto increament, and also how to set char length?