Is there any way of making queries without passing those table objects around?

[knight10-ux]

In Kysely I just need to pass table string and I'm done. I use Mikro-Orm for defining schema and kysely for making actual queries, while it's schema is generated with kysely-codegen.

[205g0]

In Kysely I just need to pass table string and I'm done.

What do you mean? Do you want to make raw sql queries?

I use Mikro-Orm for defining schema and kysely for making actual queries, while it's schema is generated with kysely-codegen.

With Drizzle you are DRY unlike your current workflow. With Drizzle you define the schema once and then, have type-safe queries without any codegen and/or need to inspect the DB to get the types (what kysely-codengen needs to do).

[knight10-ux]

What do you mean? Do you want to make raw sql queries?

In Kysely I just import main database object and have typing support for entire database:

import { Pool } from 'pg';
import { Kysely, PostgresDialect, Generated } from 'kysely';

interface MovieTable {
  id: Generated<string>
  stars: number
}

// Keys of this interface are table names.
interface Database {
  movie: MovieTable
}

const db = new Kysely<Database>({
  dialect: new PostgresDialect({
    pool: new Pool({
      host: 'localhost',
      database: 'kysely_test'
    })
  })
})

const { id } = await db
  .insertInto('movie')
  .values({ stars: 5 })
  .returning('id')
  .executeTakeFirstOrThrow()

As I look at it now, importing table objects is not the end of the world. But having an option to work on pure interfaces would be nice. Question is whether it is possible or not?

[AndriiSherman]

@mkieblesz if you like Kysely approach more, but still want to have drizzle schemas as a source of truth - you can have it!

We just creating Kysely db from drizzle schemas and then use it as a kysely package itself

https://github.com/drizzle-team/drizzle-orm/blob/main/drizzle-orm/src/kysely/README.md

[knight10-ux]

@205g0 @AndriiSherman thanks for your input. It's clear now.