Kysely•13mo ago

Unioning an array of sql`{SQL_QUERY}`

Hey chaps, I'm doing some really heinous shit with triggers etc (hence why I'm not using Kysely's default query builder syntax). I have an array of SQL queries that I'd like to

UNION ALL

UNION ALL

UNION ALL

UNION ALL together - any idea how best to do that? Note - the length of the query array is dynamic

Thanks!!

Tim LonsdaleOP•12/7/24, 2:35 PM

do I use Array.reduce?

Tim LonsdaleOP•12/7/24, 2:35 PM

I suppose that would work

Igal•12/8/24, 8:28 AM

Hey

You could pass that array to

sql.join

sql.join

import { sql } from 'kysely'

sql
  .join(
    [
      db.selectFrom("person").selectAll(),
      db.selectFrom("pet").selectAll(),
    ],
    sql` union all `,
  )
  .execute(db);

import { sql } from 'kysely'

sql
  .join(
    [
      db.selectFrom("person").selectAll(),
      db.selectFrom("pet").selectAll(),
    ],
    sql` union all `,
  )
  .execute(db);

https://kyse.link/YuLDd

Tim LonsdaleOP•12/11/24, 10:13 AM

thanks mate!

Unioning an array of sql`{SQL_QUERY}`

Similar Threads