example.mjs

import { Miniflare } from 'miniflare'

const mf = new Miniflare({
	modules: true,
	script: 'addEventListener("fetch", (event) => event.respondWith(new Response(null, { status: 404 })));',
	d1Databases: ['DEBUG'],
})

const QUERY = `
CREATE TABLE debug (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL GENERATED ALWAYS AS (JSON_EXTRACT("properties", "$.name")) STORED,
  properties TEXT NOT NULL
);
`

const db = await mf.getD1Database('DEBUG')
await db.prepare(QUERY).run()
// console.log(await db.prepare('SELECT * FROM sqlite_master').all())
await mf.dispose()

node:internal/process/task_queues:95
    runMicrotasks();
    ^

Error: D1_ERROR: SqliteError: no such column: $.name
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async file:///Users/shuymn/Works/shuymn.me/example.mjs:18:1 {
  [cause]: Error: SqliteError: no such column: $.name
      at D1Database._sendOrThrow (cloudflare-internal:d1-api:67:24)
      at async D1PreparedStatement.run (cloudflare-internal:d1-api:172:29)
      at async #fetch (entry.worker.js:813:18)
      at async ProxyServer.fetch (entry.worker.js:725:14) {
    [cause]: undefined
  }
}

Node.js v18.17.1

"miniflare": "3.20230821.0",

https://twitter.com/orisano/status/1698220635728818213