How to describe relations using column with array of ids instead junction table/parent_id?

[hambergerpls]

Hi!

const requirements = pgTable("requirements", {
    id: serial("id").primaryKey(),
    text: text("text").notNull(),
    dependencyIds: integer("dependency_ids").array(),
})

const requirementsRelations = relations(requirements, ({ one, many }) => ({
    requiredBy: many(requirements),
    dependencies: many(requirements)
})

I'm trying to create a many-to-many relationship that can self-reference itself. I know that the simplest solution is to create a junction table, but my current situation does not allow creating the junction table at the moment.

Is there a way that we can describe the relations using column with array of ids?

I prefer to query with the query API if possible.