How to Define Relationships in Drizzle ORM When a Foreign Key Can Reference Multiple Tables?

[riculum]

I'm working with Drizzle ORM and trying to fetch invoices along with related contacts and transactions. The transactions table has a referenceId column that can reference multiple tables (invoices, credits, etc.), and I use a type column to distinguish between these relationships. Here's the code I'm using:

const getInvoices = async (): Promise<Invoice[]> => {
  return db.query.invoices.findMany({
    orderBy: [desc(invoices.invoiceNumber)],
    columns: {
      contactId: false, // Exclude contactId from the invoice fields
    },
    with: {
      contact: {
        columns: {
          id: true,
          name: true,
        },
      },
      transactions: {
        where: and(
          eq(transactions.referenceId, invoices.id), // Match transactions to invoices
          eq(transactions.type, 'invoice')          // Filter by transaction type
        ),
      },
    },
  });
};

However, I'm running into the following error:
There is not enough information to infer relation "invoices.transactions".

Schema Overview
Here are the relevant parts of my schema:
invoices Table

export const invoices = pgTable('invoices', {
  id: uuid('id').defaultRandom().primaryKey().notNull(),
  invoiceNumber: varchar('invoice_number').notNull(),
  contactId: uuid('contact_id'),
  // Other columns...
});

transactions Table

export const transactions = pgTable('transactions', {
  id: uuid('id').defaultRandom().primaryKey().notNull(),
  referenceId: uuid('reference_id').notNull(),
  type: transactionTypeEnum('type').notNull(), // Can be 'invoice', 'credit', etc.
  amount: real('amount').notNull(),
  description: varchar('description').notNull(),
  paymentMethod: paymentMethodEnum('payment_method').notNull(),
  valueDate: date('value_date').notNull(),
  createdAt: timestamp('created_at').defaultNow().notNull(),
});