where

console.clear()
const l = console.log

const opAND = (fields) => {
  return Object.keys(fields)
    .map(field => opLogic(field, fields[field]))
    .join(' AND ')
}

const opOR = (fields) => {
  return Object.keys(fields)
    .map(field => opLogic(field, fields[field]))
    .join(' OR ')
}

const opEQ = (field, value) => `${field} = ${value}`

const opNE = (field, value) => `${field} != ${value}`

const operations = {
  'AND': opAND,
  'OR': opOR,
  'EQ': opEQ,
  'NE': opNE,
}

const opLogic = (field, value) => {
  if (typeof value === 'string') {
    return opEQ(field, value)
  }
  
  return Object.keys(value)
    .map(op => operations[op](field, value[op]))
}

const findOperation = (op, value) => {
  if (typeof operations[op] === 'undefined') {
    return opLogic(op, value) //
  }
  return operations[op](value)
}


const where = (attrs) => {
  const logic = Object.keys(attrs)
    .map(att => findOperation(att, attrs[att]))

  if (logic.length === 1) {
    return `WHERE \n\t${logic[0]}`
  }
  
  return `WHERE \n\t(${logic.join(")\n AND \n\t(")})\n`
}

console.log(where({
  ['AND'] : {
    name: 'David',
    email: {
      ['NE']: 'david@costa.com'
    }
  },
  ['OR'] : {
    name: 'David',
    email: 'david@costa.com'
  },
  name: 'Legal',
  idade: {
    ['NE']: 3
  }
}))