Support multi-value filtering on same column through FILTER_PARAMS

[omab]

Check List

• Tests has been run in packages where changes made if available
• Linter has been run for changed code
• Tests for the changes have been added if not covered yet
• Docs have been added / updated if required

Issue Reference this PR resolves

No related issue.

Description of Changes Made (if issue reference is not provided)

This PR adds support to properly process multiple filters over the same dimension when accessing them through FILTER_PARAMS context variable, this becomes particularly handy when the expression involved is an ILIKE operator (or similar).

With this change it's possible to define SQLs like:

cube('Foo', {
  sql: `SELECT id, name FROM foo WHERE ${FILTER_PARAMS.Foo.name.filter('name')}`,
  dimensions: {
    id: {
      type: 'number',
      sql: 'id',
      primaryKey: true
    },
    name: {
      type: 'string',
      sql: 'name'
    }
  }
}

and if the filter passed are in the form:

filters: [
  {
    dimension: 'Foo.name',
    operator: 'contains',
    values: ['Foo']
  }, {
    dimension: 'Foo.name',
    operator: 'contains',
    values: ['Bar']
  }
]

Will result in an SQL query like:

SELECT id, name FROM foo WHERE name ILIKE '%Foo%' AND name ILIKE '%Bar%';

[paveltiunov]

@omab Hey Matias! Sorry for the delay! Thanks for contributing it! Looks great!

[omab]

Thanks!