Help with a complicated statement.

export const links = sqliteTable('links', {
    slug: text('slug').primaryKey(),
    url: text('url').notNull(),
    clicks: integer('clicks').notNull().default(0)
});

export const publicLinks = sqliteTable('public_links', {
    id: integer('id').primaryKey(),
    name: text('name').notNull(),
    fill: text('fill').notNull(),
    background: text('background').notNull(),
    path: text('path').notNull()
});

export const publicLinkEntries = sqliteTable('public_link_entries', {
    id: integer('id').primaryKey(),
    linkId: integer('link_id')
        .notNull()
        .references(() => publicLinks.id),
    slug: text('slug')
        .notNull()
        .references(() => links.slug),
    title: text('title').notNull(),
    subtitle: text('subtitle').notNull()
});

[
    {
        "name": "...",
        "fill": "...",
        "background": "...",
        "path": "...",
        "clicks": 5,
        "links": [
            {
                "slug": "...",
                "title": "...",
                "subtitle": "..."
            }
        ]
    }
]