CloudFlare D1 Web Worker HTTP Proxy

db.ts

/**
 * Welcome to Cloudflare Workers! This is your first worker.
 *
 * - Run `npm run dev` in your terminal to start a development server
 * - Open a browser tab at http://localhost:8787/ to see your worker in action
 * - Run `npm run deploy` to publish your worker
 *
 * Bind resources to your worker in `wrangler.toml`. After adding bindings, a type definition for the
 * `Env` object can be regenerated with `npm run cf-typegen`.
 *
 * Learn more at https://developers.cloudflare.com/workers/
 */

export default {
	async fetch(request: Request, env: Env, ctx: ExecutionContext): Promise<Response> {
		const { sql, params, apiKey }: any = await request.json();
		try {
			if (apiKey != 'api key here') {
				throw 'invalid api key';
			}
			const query = env.DB.prepare(sql);
			const binded = query.bind(...params);
			const results = await binded.raw();
			return new Response(JSON.stringify({ results }));
		} catch (error: any) {
			const err = error?.message || error;
			return new Response(JSON.stringify({ error: { msg: err, meta: { sql, params, apiKey } } }));
		}
	},
};