routes_and_queries.js

// ------------ db/users.js -----------------
const getAll = async (params) => {
  try {
    const SQL = "SELECT * FROM reviews WHERE film_id = $/film_id/ AND app_id = $/app_id/"
    const reviews = await db.any(SQL, params);
    return reviews;
  } catch (err) {
    throw err;
  }
}

// ...other user related queries

module.exports = {
  getAll
  //...export other user related queries too
}


// ------- routes/usersRouter.js. ---------

const express = require('express');
const router = express.Router();
const Users = require("../db/Users.js");

router.get('/', async (req, res, next) => {
  try {
    const users = await Users.getAll();
    res.json({
      status: "success",
      messag: "retrieved all users",
      payload: users
    })
  } catch (err) {
    next(err)
  }
});