hey! ^^

i am trying to fetch data from my vercel postgres database and am having some issues with writing the correct query.

here you go my /api/shorten/route.ts:

import { sql } from '@vercel/postgres'
import { NextRequest, NextResponse } from 'next/server'

export async function GET(req: NextRequest) {
    const { searchParams } = req.nextUrl,
        codes = searchParams.getAll('code'),
        links = await sql`SELECT * FROM urls WHERE code IN ('${codes.join(`', '`)}')`

    console.log(`SELECT * FROM urls WHERE code IN ('${codes.join(`', '`)}')`) // returns: SELECT * FROM urls WHERE code IN ('bx1bwgms', 'phhh3jd5')

    return NextResponse.json(links.rows)
}

so, a sample api request will look like /api/get?code=foo&code=bar and i get an array of the query as ['foo', 'bar'] in the codes variable. then i convert it to a string (using the .join() method) that looks like ('foo', 'bar') to include in the sql query of the links variable. however, when i run the query, it returns an error:

ERROR: bind message supplies 1 parameters, but prepared statement "" requires 0

but if i log this query and copy, then use it (as in the comment), the code runs purrfectly normally. i can't understand why the same code fails when it includes template strings and just runs when it doesn't.

i'd like to know what i'm doing wrong here. thanks! :3