Database Query
DataExecute read-only SQL queries against your database. Returns structured results.
// db-query.ts
import { defineHandler } from '@fold-run/runtime'
export default defineHandler(async (fold) => {
const { query } = await fold.body<{ query: string }>();
// Ensure read-only access
if (!/^SELECT/i.test(query.trim())) {
return fold.json({ error: "Only SELECT queries allowed" }, 400);
}
const result = await fold.db.prepare(query).all();
return fold.json({ rows: result.results });
});