Drizzle Team•13mo ago

Get raw query from toSQL

I trying to figure out if drizzle has a function or helper built in that builds the raw query returned from toSQL right now toSQL returns params and sql as an object, i would like to get the raw sql query this is what im doing now to achieve this, any alternatives or is there a something drizzle provides i missed thanks

buildQuery(query: string, params: unknown[]) {
    let index = 1;

    return query.replace(/\$\d+/g, () => {
      const value = params[index - 1];
      index++;

      return `'${value}'`;
    });
  }

buildQuery(query: string, params: unknown[]) {
    let index = 1;

    return query.replace(/\$\d+/g, () => {
      const value = params[index - 1];
      index++;

      return `'${value}'`;
    });
  }

5 Replies

Angelelz•13mo ago

I believe .getSql() is what you're looking for Also, you might want to take a look at the dialect classes that Drizzle has

Angelelz•13mo ago

https://orm.drizzle.team/docs/sql#convert-sql-to-string-and-params

Magical sql operator 🪄 – DrizzleORM

Drizzle ORM | %s

Fleuv•8mo ago

@Angelelz it seems like the section you refer to got removed. Any idea where to find it now? Or is this still even possible?

Angelelz•8mo ago

What was removed?

Fleuv•8mo ago

Ooh nvm, I got confused because for some reason the page scrolled all the way down when I clicked on your link. If it might get removed. Then here it is now.

import { PgDialect } from 'drizzle-orm/pg-core';

const pgDialect = new PgDialect();
pgDialect.sqlToQuery(sql`select * from ${usersTable} where ${usersTable.id} = ${12}`);

import { PgDialect } from 'drizzle-orm/pg-core';

const pgDialect = new PgDialect();
pgDialect.sqlToQuery(sql`select * from ${usersTable} where ${usersTable.id} = ${12}`);

Gaming

Programming

Get raw query from toSQL