A simple helper function for building where phrases for npmjs.com/package/pg (aka node-postgres)

nodejs pg helper - getWherePhraseFromObj

const getWherePhraseFromObj = (where={}) => {
    // input {userid: 11, type: 'admin'}
    // output {wherePhrase: 'WHERE userid = $1 AND type = $2', values:[11,'admin']}
    const keys = Object.keys(where);
    const values = Object.values(where);
    console.info({keys, values});
    let wherePhrase='';
    for (let i=0; i < keys.length; i++) {
        if (! wherePhrase) {
            wherePhrase = 'WHERE '; // first time: i === 0
        } else {
            wherePhrase += ' AND ' // everything after: i > 0
        }
        const operator = Array.isArray(values[i]) && 'in' || '=';
        wherePhrase += `${keys[i]} ${operator} $${i+1}`;
    }
    console.info({wherePhrase, values});
    return {wherePhrase, values};
};
const _where = getWherePhraseFromObj;