matches2.js

const filters = {
	tamanho: 'G',
	cor: 'red'
};

const validkeys = ['tamanho','cor'];

const wheres = [];
const params = [];

Object.keys(filters).forEach(key => {
	if (!validkeys.includes(key)) return;
	wheres.push(`${key} = ?`);
	params.push(filters[key]);
});

const result = await mysql.query(`
	SELECT *			
	FROM camisas
	WHERE ${wheres.join(' OR ')}
`, params);

const matches = result.rows.map(row => {
	let qtmatches = 0;
	
	Object.keys(filters).forEach(key => {
		if (!validkeys.includes(key)) return;
		if (row[key] == filters[key]) qtmatches++;
	});

	return qtmatches;
});

console.log(matches);
//  [2,1,0];