Implement query cases

[aromeronavia]

Single condition

{name: 'Jon'}

• PG
• Memory

Implicit AND conditions

{name: 'Jon', lastName: 'Doe'}

• PG
• Memory

Three Implicit AND conditions

{name: 'Jon', lastName: 'Doe', age: 23}

• PG
• Memory

Values Range

{ createdAt: { $gte: new Date(), $lt: new Date() } }

• PG
• Memory

Three implicit AND conditions with aditional AND range

{
  name: 'Jon', 
  lastName: 'Doe', 
  age: 23,
  createdAt: { 
    $gte: new Date(), 
    $lt: new Date() 
  }
}

• PG
• Memory

Explicit OR conditions

{$or: [{name: 'Jon'}, {lastName: 'Doe'}]}

• PG
• Memory

Explicit AND conditions

{$and: [{name: 'Jon'}, {lastName: 'Doe'}]}

• PG
• Memory

Boolean condition AND a single $lt condition

{tracked: true, publishedAt: {$lt: new Date()}}

• PG
• Memory

Single Internal JSON field

{'job.title': 'Programmer'}

• PG
• Memory