Forgive me if this is a stupid error, but does anyone have any idea why on earth prepared statements

Forgive me if this is a stupid error, but does anyone have any idea why on earth prepared statements aren't working for me at all?

router.post('/:brand/:slug', async (r,e,c) => {
    const brand = r.brand;
    const slug = r.slug;
    const db = e.LINK_DB
    const body = await r.json();

    const stmt = db.prepare(`INSERT INTO ? (slug, type, data, clicks) VALUES ('?', "ArtistLanding", '?', 0)`)
    stmt.bind(brand,slug,body.data)
    return await stmt.run();
})

router.post('/:brand/:slug', async (r,e,c) => {
    const brand = r.brand;
    const slug = r.slug;
    const db = e.LINK_DB
    const body = await r.json();

    const stmt = db.prepare(`INSERT INTO ? (slug, type, data, clicks) VALUES ('?', "ArtistLanding", '?', 0)`)
    stmt.bind(brand,slug,body.data)
    return await stmt.run();
})

router.post('/:brand/:slug', async (r,e,c) => {
    const brand = r.brand;
    const slug = r.slug;
    const db = e.LINK_DB
    const body = await r.json();

    const stmt = db.prepare(`INSERT INTO ? (slug, type, data, clicks) VALUES ('?', "ArtistLanding", '?', 0)`)
    stmt.bind(brand,slug,body.data)
    return await stmt.run();
})

router.post('/:brand/:slug', async (r,e,c) => {
    const brand = r.brand;
    const slug = r.slug;
    const db = e.LINK_DB
    const body = await r.json();

    const stmt = db.prepare(`INSERT INTO ? (slug, type, data, clicks) VALUES ('?', "ArtistLanding", '?', 0)`)
    stmt.bind(brand,slug,body.data)
    return await stmt.run();
})

No matter what request I make, I always get -

{
  "status": 500,
  "error": "D1_ERROR: near \"?\": syntax error at offset 12"
}

{
  "status": 500,
  "error": "D1_ERROR: near \"?\": syntax error at offset 12"
}

{
  "status": 500,
  "error": "D1_ERROR: near \"?\": syntax error at offset 12"
}

{
  "status": 500,
  "error": "D1_ERROR: near \"?\": syntax error at offset 12"
}

The offset varies but it seems that wherever my first

?

? is in my statement, there is a syntax error, regardless of where it is in the project
I really hope I'm just being stupid and missing something obvious here!

Forgive me if this is a stupid error, but does anyone have any idea why on earth prepared statements

Similar Threads