2 replies

text mode json for sqlite Dq doesn't parse by default

I get

SyntaxError: "undefined" is not valid JSON

SyntaxError: "undefined" is not valid JSON

for

json_string: text("json_string", { mode: "json" })

json_string: text("json_string", { mode: "json" })

field.
When I use methods like:

db.query.Issue.findMany();

db.query.Issue.findMany();

db.select().from(Issue)

db.select().from(Issue)

while it does work and return string, If I manually select it by:

db.select({
  json_string: Issue.json_string
}).from(Issue)

db.select({
  json_string: Issue.json_string
}).from(Issue)

I'm using D1 db.