queryformattor.js

let query = 'select * from data where id=:id and test=:test';
let data = {
  id:1,
    test:11,
}
let data1 = {
  id:1
}

const validateQueryInput= (query:any, data:any):Promise<any> => {  
    let objectList = query.split(':');
    let values:any[]= [];
    let missingKeys :any[]= [];

    return new Promise((resolve, reject) => {
        for (let i = 1; i < objectList.length; i++) {
          const key = objectList[i].split(' ')[0];
          var myRegExp = new RegExp(`:${key}`,'i');
          query = query.replace(myRegExp,'?');
          data[key] === undefined?missingKeys.push(key):values.push(data[key])
        }
        console.log(query, values)
        console.log(missingKeys.toString())
        missingKeys.length?reject(missingKeys):resolve({query, values});
    });
}

validateQueryInput(query, data).then(e=> console.log(e)).catch(err=>console.log(err))
validateQueryInput(query, data1).then(e=> console.log(e)).catch(err=>console.log(err))

Format key value pair into array values in mysql query