Yes the new nested queries will perform much better, specially when you have many nested records.
It should also work just fine with custom databases as long as you have your relations well defined with keys and sub tables prefixed with the main table name.
The database manager will auto import such schema’s on tables schema refresh.