feat(builder): add support to nested filters

[JoaoPedroAS51]

Add support to nested filters to where and whereIn.

Closes #81

TODO

• Update documentation of where and whereIn

Usage

await Model.where(['user', 'status'], 'active').get()
// GET /resource?filter[user][status]=active

await Model.whereIn(['user', 'status'], ['active', 'inactive']).get()
// GET /resource?filter[user][status]=active,inactive

[Peter-Krebs]

That's a good step forward, thanks!

Only problem I can see is the lack of CRUD, which I like to implement for anything.
Currently, you would not be able to add or remove values for an existing key, only overwrite them, correct? It's not strictly neccessary but worth thinking about, you know someone is going to request that sooner or later.

[JoaoPedroAS51]

@Peter-Krebs I'm afraid I didn't understand. Can you open a new issue for this, so we could discuss more about it?

[JoaoPedroAS51]

@Peter-Krebs This PR is only related to nested filters support. Any other improvement will be handle in a new PR.

[Peter-Krebs]

@JoaoPedroAS51 Yes I'm talking about the filters.

Consider this call:
await Model.whereIn(['user', 'status'], ['active', 'inactive'])

It would be nice to modify filters as well instead of just replacing the whole value.
But I'm fine with your current solution, I just wanted to hear what you think about it.

[JoaoPedroAS51]

@Peter-Krebs I'm afraid that making such change would break the current structure we are following in this package, which I believe was inspired by Laravel’s Eloquent.

Maybe you could provide an usage example where adding and removing filters would be useful. That way we can think together in a solution :)

I recommend opening a new issue to discuss about this, because such change is outside the scope of this PR.

What do you think @robsontenorio?

[robsontenorio]

I think we can get started with the simple solution.

[github-actions]

🎉 This PR is included in version 1.8.0 🎉

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot 📦🚀

[dionysiosarvanitis]

Seems like solution does not support two nested values or am I doing something wrong?

query.where(['schedule', 'start'], start)
    .where(['schedule', 'end'], end)

[JoaoPedroAS51]

Hi @dionysiosarvanitis! Thank you for your report. I'm working on a fix for your issue :)

[JoaoPedroAS51]

@dionysiosarvanitis Done #154 😉

[dionysiosarvanitis]

@JoaoPedroAS51 that was really quick! Thank you!