drizzle to log queries

[alexmondaini]

Hello folks,

I've just moved from prisma to drizzle and in prisma I can see the conversion of my orm/queries into sql by instatiating the prisma client with log: ['query'] as in https://www.prisma.io/docs/orm/prisma-client/observability-and-logging/logging#log-to-stdout.

I'm wondering whether I can do the same with drizzle.config.ts or when instatiating my client. I use Postgres.JS , thanks

[sumitkolhe]

@alexmondaini yes you can do that by setting logger: true in the drizzle client. https://orm.drizzle.team/docs/goodies#logging

[alexmondaini]

thanks, i missed that in the docs

[AlexBlokh]

you can also always invoke .toSQL on every drizzle query you want to see resulting SQL for