Passing SQL to an sql.placeholder()

drizzle orm📚sqlpostgres-js

Never thought I'd ever need to ask help with drizzle but here I am.
So, I have a setup that looks a little like this:

const whereClauses: SQL[] = [];

if (condition1) whereClauses.push(sql`${table.row} ...`);
if (condition2) whereClauses.push(sql`${table.row} ...`);
// etc.

const whereClauses: SQL[] = [];

if (condition1) whereClauses.push(sql`${table.row} ...`);
if (condition2) whereClauses.push(sql`${table.row} ...`);
// etc.

And I have a prepared query a little like:

const preparedQuery = db.select({ ... }).from(table).(a few joins).where(sql.placeholder('where'));

const preparedQuery = db.select({ ... }).from(table).(a few joins).where(sql.placeholder('where'));

(Switched from just '.where(sql`...`)' to this once I added condition based clauses)
And I actually don't know how I can pass my whereClauses into this. A few options in my brain are:

where: sql.join(whereClauses, sql.raw(' AND ')) // I'm not sure if sql.placeholder or anything would handle this SQL object, or if I can just convert this SQL to a string, I can't find clear documentation on it
where: whereClauses.reduce((a, b) => a ? sql`${a} AND ${b}` : b, null)) // Still would be SQL object, so same issue

where: sql.join(whereClauses, sql.raw(' AND ')) // I'm not sure if sql.placeholder or anything would handle this SQL object, or if I can just convert this SQL to a string, I can't find clear documentation on it
where: whereClauses.reduce((a, b) => a ? sql`${a} AND ${b}` : b, null)) // Still would be SQL object, so same issue

The only other idea I had was doing my original idea, then using a bunch of 'sql``.if(...)', but I feel that has the potential to be a lot more messy so I'm hesitant on that approach

If someone could help me with this I'd really appreciate it. If I can't really do this with a prepared query I'd understand and I can make it not a prepared query and do it another way. Any way to make it work?
Thanks in advance

Passing SQL to an sql.placeholder()

drizzle orm📚sqlpostgres-js

Never thought I'd ever need to ask help with drizzle but here I am.
So, I have a setup that looks a little like this:

const whereClauses: SQL[] = [];

if (condition1) whereClauses.push(sql`${table.row} ...`);
if (condition2) whereClauses.push(sql`${table.row} ...`);
// etc.

const whereClauses: SQL[] = [];

if (condition1) whereClauses.push(sql`${table.row} ...`);
if (condition2) whereClauses.push(sql`${table.row} ...`);
// etc.

And I have a prepared query a little like:

const preparedQuery = db.select({ ... }).from(table).(a few joins).where(sql.placeholder('where'));

const preparedQuery = db.select({ ... }).from(table).(a few joins).where(sql.placeholder('where'));

(Switched from just '.where(sql`...`)' to this once I added condition based clauses)
And I actually don't know how I can pass my whereClauses into this. A few options in my brain are:

where: sql.join(whereClauses, sql.raw(' AND ')) // I'm not sure if sql.placeholder or anything would handle this SQL object, or if I can just convert this SQL to a string, I can't find clear documentation on it
where: whereClauses.reduce((a, b) => a ? sql`${a} AND ${b}` : b, null)) // Still would be SQL object, so same issue

where: sql.join(whereClauses, sql.raw(' AND ')) // I'm not sure if sql.placeholder or anything would handle this SQL object, or if I can just convert this SQL to a string, I can't find clear documentation on it
where: whereClauses.reduce((a, b) => a ? sql`${a} AND ${b}` : b, null)) // Still would be SQL object, so same issue

Passing SQL to an sql.placeholder()

Similar Threads

Passing SQL to an sql.placeholder()

Similar Threads

Similar Threads

Similar Threads