How to do a TRUNCATE query with multiple tables?

[sebastorama]

Hi, I'm just starting to use Slonik and currently trying to setup testing.

I could gather all the table names successfully, but can't generate the actual truncate query, like so:

  const truncateQuery = sql.unsafe`TRUNCATE TABLE ${sql.join(
    tables,
    sql.fragment`, `
  )} CASCADE;`;

  await connect((c) => c.any(truncateQuery));

This is giving me a error: syntax error at or near "$1".

Logging the query object gives me:

console.log
    {
      sql: 'TRUNCATE TABLE $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15 CASCADE;',
      values: [
        'organizations',
        'tags',
        'races',
        'users',
        'roles',
        'price_checkpoints',
        'untagged_bovine_movements',
        'weight_records',
        'bovines',
        'bovines_tags',
        'farms',
        'locations',
        'bovine_movements',
        'bovine_location_lists',
        'weighting_sessions'
      ],
      parser: ZodAny {
        spa: [Function: bound safeParseAsync] AsyncFunction,
        _def: { typeName: 'ZodAny' },
        parse: [Function: bound parse],
        safeParse: [Function: bound safeParse],
        parseAsync: [Function: bound parseAsync] AsyncFunction,
        safeParseAsync: [Function: bound safeParseAsync] AsyncFunction,
        refine: [Function: bound refine],
        refinement: [Function: bound refinement],
        superRefine: [Function: bound superRefine],
        optional: [Function: bound optional],
        nullable: [Function: bound nullable],
        nullish: [Function: bound nullish],
        array: [Function: bound array],
        promise: [Function: bound promise],
        or: [Function: bound or],
        and: [Function: bound and],
        transform: [Function: bound transform],
        brand: [Function: bound brand],
        default: [Function: bound default],
        catch: [Function: bound catch],
        describe: [Function: bound describe],
        pipe: [Function: bound pipe],
        isNullable: [Function: bound isNullable],
        isOptional: [Function: bound isOptional],
        _any: true
      },
      type: 'SLONIK_TOKEN_QUERY'
    }

Any ideas?