``` const createQuery = (query) => { const re...
# orm-help
c
Copy code
const createQuery = (query) => {
  const returnQuery = `${query} `.replace(/"/g, '\\"').replace(/\n/g, ' ').replace(/\s+/g, ' ');
  return returnQuery;
};

const executeQuery = async (query) => {
  const fixedQuery = createQuery(query);
  const response = await prisma.$graphql(`
  mutation {
    executeRaw(query: "${fixedQuery}")
  }
`);

  return response.executeRaw;
};
    const results = await executeQuery('SELECT count("id") FROM "default$default"."YourTable" group by "yourField"');