JonasDov

closes #1100

### Steps to reproduce Running the following: ```sql WITH TestCte(x) AS (VALUES('a'), ('b')) SELECT * FROM TestCte ``` Results in parse error. However, when using `VALUES(...),(...)` not inside CTE, it...

The following ECSQL statement: ```sql SELECT * FROM (VALUES(1), (2), (3)) ``` Gets converted to: ```sql SELECT [K0] FROM (SELECT 1 [K0] UNION ALL SELECT 2 UNION ALL SELECT 3)...

This test is flaky: `Property grid > Learning snippets > Context menu item > renders context menu item`. The test should be enabled after the fix

The changes are already in master, but it has to be done separately from https://github.com/iTwin/viewer-components-react/pull/1511. This change requires updating models/categories/classifications tree visibility handlers to have this functionality. Changes should be...

Performance tests on next branch show that main thread is blocked for a long time in some cases. This needs to be fixed after https://github.com/iTwin/viewer-components-react/pull/1511 is merged. ```md Status |...

WIP

Tree widget: Add cache context provider

1

Models, categories and classifications trees use similar cache implementations. They can be unified and shared across these different trees. This will not only reduce code duplication, but will also reduce...