🐛 BUG: D1 export will fail if a table column is named "index"

[OpenSource03]

Which Cloudflare product(s) does this pertain to?

D1, Wrangler

What version(s) of the tool(s) are you using?

3.76.0 (Wrangler)

What version of Node are you using?

20

What operating system and version are you using?

MacOS 15.1 Beta

Describe the Bug

Observed behavior

D1 export fails if there is a table named "index"

Expected behavior

I guess, if that's not an SQLite related thing, and most likely is not, as I am able to create the table with these column naming, there should be no error.

Steps to reproduce

Make a database, for example, with the following model

model Status {
  id    Int    @id @default(autoincrement())
  index Int    @default(0)
  name  String
  color String
  text  String
  icon  String
  posts Post[]
}

Insert a few rows of random data and try to export it.

My data:

┌────┬───────┬───────────────┬─────────┬─────────────────────────┬──────────────────┐
│ id │ index │ name          │ color   │ text                    │ icon             │
├────┼───────┼───────────────┼─────────┼─────────────────────────┼──────────────────┤
│ 0  │ 1     │ Native        │ #10b981 │ Yes, natively supported │ CheckmarkRegular │
├────┼───────┼───────────────┼─────────┼─────────────────────────┼──────────────────┤
│ 1  │ 1     │ Emulated      │ green   │ Active                  │ check            │
├────┼───────┼───────────────┼─────────┼─────────────────────────┼──────────────────┤
│ 2  │ 2     │ Not supported │ yellow  │ Pending                 │ clock            │
├────┼───────┼───────────────┼─────────┼─────────────────────────┼──────────────────┤
│ 3  │ 3     │ Beta Support  │ red     │ Inactive                │ x                │
└────┴───────┴───────────────┴─────────┴─────────────────────────┴──────────────────┘

Please provide a link to a minimal reproduction

No response

Please provide any relevant error logs

 ⛅️ wrangler 3.76.0
-------------------

🌀 Exporting local database windows-on-arm (87be6381-bcc2-45d5-a843-f2cec24a69f0) from .wrangler/state/v3/d1:
🌀 To export your remote database, add a --remote flag to your wrangler command.
🌀 Exporting SQL to ./export/posts.sql...

✘ [ERROR] D1_ERROR: Failed to parse body as JSON, got: Error: near "index": syntax error at offset 11: SQLITE_ERROR

      at dumpSql
  (file:///Users/dejanzegarac/PhpstormProjects/windowsonarm-cf/node_modules/.pnpm/[email protected]/node_modules/miniflare/dist/src/workers/d1/database.worker.js:49:65)
      at dumpSql.next (<anonymous>)
      at Function.from (<anonymous>)
      at #doExportData
  (file:///Users/dejanzegarac/PhpstormProjects/windowsonarm-cf/node_modules/.pnpm/[email protected]/node_modules/miniflare/dist/src/workers/d1/database.worker.js:337:23)
      at D1DatabaseObject.queryExecute
  (file:///Users/dejanzegarac/PhpstormProjects/windowsonarm-cf/node_modules/.pnpm/[email protected]/node_modules/miniflare/dist/src/workers/d1/database.worker.js:320:32)
      at async D1DatabaseObject.fetch
  (file:///Users/dejanzegarac/PhpstormProjects/windowsonarm-cf/node_modules/.pnpm/[email protected]/node_modules/miniflare/dist/src/workers/shared/index.worker.js:377:18)
      at async D1DatabaseObject.fetch
  (file:///Users/dejanzegarac/PhpstormProjects/windowsonarm-cf/node_modules/.pnpm/[email protected]/node_modules/miniflare/dist/src/workers/shared/index.worker.js:542:14)


🪵  Logs were written to "/Users/dejanzegarac/.wrangler/logs/wrangler-2024-09-11_11-20-25_015.log"