DB.prepare('select * from blog').all() But the stored frontmatter is returning json as string instead of automatically parsing it out as json. 
CREATE TABLE blog (
id TEXT PRIMARY KEY,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
content_url TEXT,
frontmatter JSON,
slug TEXT UNIQUE,
title TEXT,
website_ref_id TEXT,
FOREIGN KEY (website_ref_id) REFERENCES website(id)
);DB.prepare('select * from blog').all()
M
C
JSON.parse()
K
CCKGLOB should already be limited, as LIKE & GLOB are supposed to be controlled by SQLITE_LIMIT_LIKE_PATTERN_LENGTH which is set to 50.CKCK
GLOB is limited to 50 bytes as documented for me
CC
KK
D
UU
SUSU
afaik the only documented usage of D1 is through workersS
MMSMMM
HSSSMSMSSSMKK
KE
npx wrangler d1 migrations applyy
CSselect id,
content_url,
json(frontmatter) as frontmatter,
slug,
title,
website_ref_id,
created_at
from blogGLOBGLOBGLOBLIKESQLITE_LIMIT_LIKE_PATTERN_LENGTHd1.prepare('select * from abc where id in(?,?)').bind(1,2)