camelcase？ about kysely HOT 8 CLOSED

@xiaoyu-tamu I just added the first version of the plugin interface and a plugin called CamelCasePlugin

from kysely.

Yep. I'll add a plugin interface and implement a camelCase conversion as a plugin.

from kysely.

Yes.

from kysely.

that would be nice!

from kysely.

Hi, @koskimas

I just tried it and it works as expected

from kysely.

However, the conversion will be done for the SQL as well as the return value, as they are defined using the same interfaces. For example, if you have a table person_table with columns id and first_name, the conversion would work like this:

interface Person {
  id: string
  firstName: string
}

interface Database {
  personTable: Person
}

const db = new Kysely<Database>(...)

await db.selectFrom('personTable').select('id').where('firstName', '=', 'Sami')

So EVERYTHING needs to be converted to camelCase by the plugin, or else the type system won't work. Kysely won't allow the return value column names to be different from the ones used in the queries.

from kysely.

what's the generated sql for this query?

await db.selectFrom('personTable').select('id').where('firstName', '=', 'Sami')

will the above query generate as this sql?

select id from person_table where first_name = 'Sami' 

from kysely.

will try it later today.

from kysely.