Support limiting length of strings

[zygopleural]

At the moment, in order to limit the length of strings, I need to do:

const User = createModel((User) => {
  User
    .string("id", { id: true })
    .string("setupId", { raw: "@database.VarChar(36)" })
})

It would be nice to support something like

const User = createModel((User) => {
  User
    .string("id", { id: true })
    .string("setupId", { maxLength: 36 })
})

or

const User = createModel((User) => {
  User
    .string("id", { id: true })
    .varChar("setupId", { limit: 36 })
})

or

const User = createModel((User) => {
  User
    .string("id", { id: true })
    .varChar("setupId", 36)
})

In order to add the "@database.VarChar(36)" automatically.

[ridafkih]

The difficulty here would be that different database engines support different datatypes, so we'll need to map those out.

[zygopleural]

The difficulty here would be that different database engines support different datatypes

I was under the assumption this library only supported postgres

[ridafkih]

@zygopleural At the moment, yes, it primarily supports Postgres, but I also use it personally for cockroachdb. We could implement these features open-ended so it's still expected that the user knows which method to use for their database engine, we could compute it on our end, or we could default to postgres and provide the functionality to override. Quite a few avenues there.