Using the Any Match Virtual Table
Connector versions 1.8.4 and earlier include support for a special virtual table called the Any Match virtual table. This table is used to support queries that filter data based on multiple top-level array values, enabling such queries to be executed using significantly shorter statements.
The Any Match virtual table is deprecated as of connector version 2.0.0, but it is still possible to re-enable and use this feature. However, note that in order to do so, you must disable the Enable Mixed Type Filter option (the EnableMixedTypeFilter property). For more information, see Enable Mixed Type Filter.