when using Engine=MySQL for table or database - can i hint ClickHouse to pass WHERE condition to underlying MySQL?

let's say i have a MySQL database 'mounted' to ClickHouse 24.3.2 via:

```
CREATE DATABASE mydb ENGINE = MySQL('host', 'db', 'login', 'pass')
```

i've noticed that most of more complex queries lead to ClickHouse reading the whole table from MySQL.

example query:

```
SELECT * FROM content WHERE transaction_id IN ( SELECT id FROM transaction WHERE object_id=1234 )
```

while i don't expect ClickHouse to pass the whole query to MySQL - i'd love to hint ClickHouse that it should compile list of ids from the subquery and then pass it to MySQL for the outer query instead of loading whole content table from MySQL and only then doing the filtering.

thank you!