wix-data-sql-backend-endpoint.js

import { ok, serverError } from 'wix-http-functions';
import { sql } from '@velo/wix-data-sql-backend';

/**
 * @param {import("wix-http-functions").WixHttpFunctionRequest} request
 */
export async function post_sql(request) {
    try {

        const reqBody = await request.body.json()
        const result = await sql(reqBody.sqlStr);
        return ok({
            body: { result },
            headers: { 'Content-Type': 'application/json' },
        })
    } catch (error) {
        console.error('error: ', error)

        return serverError({
            body: error,
            headers: { "Content-Type": "application/json" }
        })
    }
}