raw query using sql

[arashsheyda]

I'm trying to use a raw query like this:

const q = sql`SELECT * FROM "users"`
return await useDB().all(q)

when I return q itself it's like:

{  "queryChunks": [
    {
      "value": [
        "SELECT * FROM \"users\""
      ]
    }
  ],
  "decoder": {
    
  },
  "shouldInlineParams": false
}

and it works fine but when i want my query to be dynamic, it doesn't work somehow

const table = 'users'
const q = sql`SELECT * FROM "${table}"`
return await useDB().all(q)

when i return q is like:

{
  "queryChunks": [
    {
      "value": [
        "SELECT * FROM \""
      ]
    },
    "users",
    {
      "value": [
        "\""
      ]
    }
  ],
  "decoder": {
    
  },
  "shouldInlineParams": false
}

thank you