feat(filter): add support for more operators than contains

[roggervalf]

When filtering data, by default, default-type component generates urls where records are going to be filtered by attribute using contains operations. This pr provides a way to choose different operators and reflect that in the url. Operators are: startsWith, endsWith, equals, notEquals and contains (default) operators. Or operator is supported too. Updates were added to these adapters as well:

• Sequelize
• Objectionjs
• Mongoose
• Typeorm
• Prisma
• Mikroorm

[roggervalf]

pls @dziraf when you get some time to take a look

[dziraf]

This is a good start but ideally the entire filter system should be rebuilt to allow AND, OR and NOT plus we should use symbols for operators. This would also require us to update all adapters to make sure the app works the same regardless of your ORM/ODM/database

[roggervalf]

This is a good start but ideally the entire filter system should be rebuilt to allow AND, OR and NOT plus we should use symbols for operators. This would also require us to update all adapters to make sure the app works the same regardless of your ORM/ODM/database

hey @dziraf, I added this functionality into adapters and covered the other operators that you mentioned. Pls when you get some time

[Visot]

Having support for multiple operators would be really useful. It adds flexibility to how we filter data and makes the component much more versatile in different use cases.