1 reply

Is it possible to create a query without having a (postgres) db instance?

I can do this:

const query = sql`SELECT ... FROM...`;
const db = drizzle(..., {schema});
db.execute(query);

const query = sql`SELECT ... FROM...`;
const db = drizzle(..., {schema});
db.execute(query);

But is there anyway to do something like this:

const query = dummy.select(...).from(...);
const db = drizzle(..., {schema});
db.execute(query);

const query = dummy.select(...).from(...);
const db = drizzle(..., {schema});
db.execute(query);

It seems if I manually define the query like in the good old days I can pre-write a query ahead of time.
But if I want to access the type-safe universe, it looks like I need to have a db instance set up BEFORE I use it to compose the query.

I have a use case where I'd like to prewrite several queries for a query catalog.
This catalog is built before the db object is instantiated.

Drizzle Team•2y ago•

1 reply

mediumhype

Is it possible to create a query without having a (postgres) db instance?

I can do this:

const query = sql`SELECT ... FROM...`;
const db = drizzle(..., {schema});
db.execute(query);

const query = sql`SELECT ... FROM...`;
const db = drizzle(..., {schema});
db.execute(query);

But is there anyway to do something like this:

const query = dummy.select(...).from(...);
const db = drizzle(..., {schema});
db.execute(query);

const query = dummy.select(...).from(...);
const db = drizzle(..., {schema});
db.execute(query);

Is it possible to create a query without having a (postgres) db instance?

Similar Threads

Is it possible to create a query without having a (postgres) db instance?

Similar Threads

Similar Threads

Similar Threads