sequely

Backend

const { sq } = require("sequely");
const { Users, Posts } = require("../models");

async function getUsersList(req, res){

    try{

        let users = await sq(Users, req, (options)=>{ 
      
            options.include = { model: Posts, required: false }

        });

        res.status(200).send(users);
    
    }catch(e){
        res.status(500).send(e.message);
    }

}

Frontend

import axios from "axios";

async function getUsersList(){

    try{

        let query = JSON.stringify({
            filter: { name: "Don" },               
            filter_in: { id: [ 1, 2, 3 ] },        
            filter_notin: { id: [ 1, 2, 3 ] },     
            search: { name: "do", email: "do" },                
            sort: ["id", "DESC"],                  
            between: { age: { from: 10, to: 20 } },

            pagination: true, // default true
            page: 2,          // working when pagination is true
            limit: 10,        // working when pagination is true , default value 10
        });

        let users = await axios.get("http://domain.com/users", { params: { query } });

        console.log(users);
    
    }catch(e){
        console.log(e.message);
    }

}