15-Explain

explain verbose true with CASE WHEN subquery

1. EXPLAIN VERBOSE TRUE on a query that uses CASE WHEN inside a subquery

with the outer WHERE filtering on the computed CASE column should not crash.

2. The scan time range reported by EXPLAIN VERBOSE TRUE must match the

explicit ts filters in the inner WHERE clause, not the full history range.

path: cases/09-DataQuerying/15-Explain/test_explain_case_when.py

Explain command basic

1. Performing EXPLAIN on queries involving various functions, windows, subqueries, and sorting operations

2. Verify bug TD-20582 (explain order by sql error)

path: cases/09-DataQuerying/15-Explain/test_query_explain.py

Test explain in analyze mode.

These cases cover almost all operators and their combinations.

path: cases/09-DataQuerying/15-Explain/test_query_explain.py