Yes. Subqueries also get re-written for using index. And with the second query in testNestedSubqueries(), you can see that filters in the main query also get pushed down into inner queries.