Hi Roel,

The query model offered by joli.js is rather consistant and almost allows what you are asking. For instance, it is possible to search records at a class-level:

// returns one 'City' record
models.city.findOneBy('name', 'Paris');

// returns a collection of 'Human' records
models.human.findBy('city_id', 12);

You can just not chain the findBy() calls, eg. models.human.findBy('city_id', 12).findBy('first_name', 'Michel'); For such needs, there are two ways in joli.js:

1- use the abstract query language:

// returns the humans living in the city 12 and with "Michel" as first name
var q = new joli.query().select().from('human').where('city_id = ?', 12).andWhere('first_name = ?', 'Michel');
var humans = q.execute();

Note that this approach as a major benefit over plain SQL: it allows to build queries over several methods / functions, and to progressively add restrictions on queries objects. This is particularly useful in the seek for code mutualisation.

2- use the class-level "all()" finder :

// returns the humans living in the city 12 and with "Michel" as first name
var humans = models.human.all({
  where: [
    'city_id = ?': 12,
    'first_name = ?': 'Michel',
  ]
});

Have a look at joli.js's code, or rather at the test suite, which provides a lot of useful examples: https://github.com/xavierlacot/joli.js-demo/tree/master/Resources/test