Using magic SQL operator with 2 SQL dbs

Hi folks,

In my project I need to connect to both separate mysql and postgres databases.
I am able to successfully do so and create database objects but trying to execute raw SQL is not working currently using the magic SQL wrapper syntax.
Typescript is confused because it does not know how to assign the types for sql as it tries to assign them from mysql and pg types

import { langlfowDb } from "..";
import { sql } from "drizzle-orm";


export const queryAgents = async () => {
  const result = await langlfowDb.execute(
    sql`select * from flow where locked = true;`,
  );
  console.log(result);
};

import { langlfowDb } from "..";
import { sql } from "drizzle-orm";


export const queryAgents = async () => {
  const result = await langlfowDb.execute(
    sql`select * from flow where locked = true;`,
  );
  console.log(result);
};

I get this error message:

Argument of type 'SQL<unknown>' is not assignable to parameter of type 'SQLWrapper'.
  The types returned by 'getSQL()' are incompatible between these types.
    Type 'import("/Users/revan/dev/archeAi/nextarche/node_modules/.pnpm/drizzle-orm@0.32.2_@opentelemetry+api@1.9.0_@types+react@18.3.3_mysql2@3.11.0_react@18.3.1/node_modules/drizzle-orm/sql/sql").SQL<unknown>' is not assignable to type 'import("/Users/revan/dev/archeAi/nextarche/node_modules/.pnpm/drizzle-orm@0.32.2_@opentelemetry+api@1.9.0_@types+pg@8.11.11_@types+react@18.3.3_mysql2@3.11.0_pg@8.13.1_react@18.3.1/node_modules/drizzle-orm/sql/sql").SQL<unknown>'.
      Types have separate declarations of a private property 'shouldInlineParams'.ts(2345)

Argument of type 'SQL<unknown>' is not assignable to parameter of type 'SQLWrapper'.
  The types returned by 'getSQL()' are incompatible between these types.
    Type 'import("/Users/revan/dev/archeAi/nextarche/node_modules/.pnpm/drizzle-orm@0.32.2_@opentelemetry+api@1.9.0_@types+react@18.3.3_mysql2@3.11.0_react@18.3.1/node_modules/drizzle-orm/sql/sql").SQL<unknown>' is not assignable to type 'import("/Users/revan/dev/archeAi/nextarche/node_modules/.pnpm/drizzle-orm@0.32.2_@opentelemetry+api@1.9.0_@types+pg@8.11.11_@types+react@18.3.3_mysql2@3.11.0_pg@8.13.1_react@18.3.1/node_modules/drizzle-orm/sql/sql").SQL<unknown>'.
      Types have separate declarations of a private property 'shouldInlineParams'.ts(2345)

How can resolve this issue?

Drizzle Team•13mo ago

Brando

Using magic SQL operator with 2 SQL dbs

import { langlfowDb } from "..";
import { sql } from "drizzle-orm";


export const queryAgents = async () => {
  const result = await langlfowDb.execute(
    sql`select * from flow where locked = true;`,
  );
  console.log(result);
};

import { langlfowDb } from "..";
import { sql } from "drizzle-orm";


export const queryAgents = async () => {
  const result = await langlfowDb.execute(
    sql`select * from flow where locked = true;`,
  );
  console.log(result);
};

I get this error message:

Argument of type 'SQL<unknown>' is not assignable to parameter of type 'SQLWrapper'.
  The types returned by 'getSQL()' are incompatible between these types.
    Type 'import("/Users/revan/dev/archeAi/nextarche/node_modules/.pnpm/drizzle-orm@0.32.2_@opentelemetry+api@1.9.0_@types+react@18.3.3_mysql2@3.11.0_react@18.3.1/node_modules/drizzle-orm/sql/sql").SQL<unknown>' is not assignable to type 'import("/Users/revan/dev/archeAi/nextarche/node_modules/.pnpm/drizzle-orm@0.32.2_@opentelemetry+api@1.9.0_@types+pg@8.11.11_@types+react@18.3.3_mysql2@3.11.0_pg@8.13.1_react@18.3.1/node_modules/drizzle-orm/sql/sql").SQL<unknown>'.
      Types have separate declarations of a private property 'shouldInlineParams'.ts(2345)

Argument of type 'SQL<unknown>' is not assignable to parameter of type 'SQLWrapper'.
  The types returned by 'getSQL()' are incompatible between these types.
    Type 'import("/Users/revan/dev/archeAi/nextarche/node_modules/.pnpm/drizzle-orm@0.32.2_@opentelemetry+api@1.9.0_@types+react@18.3.3_mysql2@3.11.0_react@18.3.1/node_modules/drizzle-orm/sql/sql").SQL<unknown>' is not assignable to type 'import("/Users/revan/dev/archeAi/nextarche/node_modules/.pnpm/drizzle-orm@0.32.2_@opentelemetry+api@1.9.0_@types+pg@8.11.11_@types+react@18.3.3_mysql2@3.11.0_pg@8.13.1_react@18.3.1/node_modules/drizzle-orm/sql/sql").SQL<unknown>'.
      Types have separate declarations of a private property 'shouldInlineParams'.ts(2345)

How can resolve this issue?

Using magic SQL operator with 2 SQL dbs

Similar Threads

Using magic SQL operator with 2 SQL dbs

Similar Threads

Similar Threads

Similar Threads