Advanced filter with OR or AND operators

I have a field of type tags and I need a filter of records with tag1 AND tag2 or tag1 OR tag2

similary by multi choise - there is possible set filter by click the coises but it is with OR operator - that is for most cases good but not for All

Is there a way to set more complex filtering rules? Thank you

In the UI - combining AND and OR is currently not possible.
You can change AND operator to OR in a card view.
We want to improve this in the future.
You can use any combinations when using API

or scripting (doo.table)